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...
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.