topic Re: Generate number series based on other column number first number change in DAX Commands and Tips

Generate number series based on other column number first number change

Anonymous — Fri, 03 Nov 2023 06:26:54 GMT

I want Generate Number based on ther other column first number 1 chanage . attached sample input Data for reference

Table

task task number
dd 1
ww 2
qw 3
ty 4
yu 5

if Number 1 changed to 2 order output look like

task task number calcaulted column
dd 2 2
ww 2 3
qw 3 4
ty 4 5
yu 5 6

if Number 1 changed to 3 order output look like

task task number calcaulted column
dd 3 3
ww 2 4
qw 3 5
ty 4 6
yu 5 7

if Number 1 changed to 4 order output look like

task task number calcaulted column
dd 4 4
ww 2 5
qw 3 6
ty 4 7
yu 5 8.

attached Sample Data Sample

Thanks in advance . Looking For support

Re: Generate number series based on other column number first number change

wdx223_Daniel — Fri, 03 Nov 2023 01:01:26 GMT

CalculatedColumn=VAR _start=MAXX(TOPN(Table,Table[task],ASC),Table[task number]) RETURN COUNTROWS(FILTER(Table,Table[task]<EARLIER(Table[task])))+_start

Re: Generate number series based on other column number first number change

Anonymous — Fri, 03 Nov 2023 02:35:11 GMT

I got Error cannot find the type task priority

Re: Generate number series based on other column number first number change

v-zhangti — Mon, 06 Nov 2023 08:27:48 GMT

Hi, Anonymous

You can try the following methods.

Column = Var _first=CALCULATE(MAX('Table'[task number]),FILTER('Table',[Index]=1)) Return IF([Index]=1,[task number],CALCULATE(COUNT('Table'[task]),FILTER('Table',[Index]<EARLIER('Table'[Index])))+_first)

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.