Forum Discussion
Consecutive numbers
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,
2 Replies
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
