Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
Is there a way for PBI to extract consecutive numbers across columns and ignore the rest?
Item 1 | Item 2 | Item 3 | Item 4 | Item 5 | Item 6 | Item 7 | Item 8 |
23 | 22 | 17 | 11 | 32 | 6 | 13 | 15 |
45 | 5 | 19 | 11 | 23 | 27 | 10 | 13 |
9 | 8 | 25 | 7 | 26 | 2 | 24 | 9 |
Thank you,
Hi @matrix_user ,
As far as I know, the calculation in Power BI should be between columns. I think your requirement is to find extract consecutive numbers in same rows across columns. It is hard for us to achieve your goal based on this data model.
I suggest you to add an [Index] column in Power Query Editor and unpivot your [Item N] columns.
And I think you may need to add a column with looping.
For reference:
List.Generate() and Looping in PowerQuery
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
41 | |
27 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
19 | |
18 | |
15 |