Consecutive numbers

[matrix_user]

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,

[v-rzhou-msft]

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.

[daXtreme]

https://community.powerbi.com/t5/DAX-Commands-and-Tips/How-to-Get-Your-Question-Answered-Quickly/td-...