Solved: Incrementing column based on another column

akshaydz · ‎08-01-2018

I am looking to generate an incrementing column for my table as shown below

Can anybody help me with DAX function or M code to populate the Expected column as above

Zubair_Muhammad · ‎08-01-2018

Colum=rankx(filter(table1, [product] =earlier([product])), [date],, asc, dense)

Regards
Zubair

Please try my custom visuals

Zubair_Muhammad · ‎08-01-2018

Colum=rankx(filter(table1, [product] =earlier([product])), [date],, asc, dense)

Regards
Zubair

Please try my custom visuals

Incrementing column based on another column