Power Query Challenge 11: Identifying Frequent Codes - Solving with List.Transform
HTML-код
- Опубликовано: 3 окт 2024
- In this Power Query challenge, we dive into Challenge 11 using List.Transform to solve the task of identifying frequent codes. The goal is to extract all item codes that are repeated in at least 3 out of the 4 columns presented in the question table. Follow along as I demonstrate a clever approach to solving this challenge step-by-step with Power Query.
#PowerQuery #ListTransform #DataTransformation #Excel
👏👏👏🔝
@@wildecorrea6477 🙏🙏
Great PQ solution !!
Formula alternative:
=LET(a,I3:L16,UNIQUE(SORT(TOCOL(IFS(MAP(a,LAMBDA(x,SUM(--BYCOL(x=a,OR))>2)),a),2))))
@@Excelambda 🙏🙏❣️
Thanks
@@themolestones You are welcome