topic Re: Consecutive numbers in DAX Commands and Tips

Consecutive numbers

matrix_user — Wed, 10 Aug 2022 08:40:47 GMT

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,

Re: Consecutive numbers

daXtreme — Wed, 10 Aug 2022 13:39:12 GMT

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

Re: Consecutive numbers

Anonymous — Wed, 24 Aug 2022 07:43:11 GMT

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.