Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
57 | |
21 | |
18 | |
16 | |
12 |
User | Count |
---|---|
85 | |
54 | |
39 | |
21 | |
18 |