Forum Discussion

ivandelgra's avatar
ivandelgra
Icon for Helper I rankHelper I
6 years ago

How to count instance changes in a column YoY

Hello I have this dataset:   ID PERSON CARD TYPE SUBSCRIPTION YEAR A FREE 2018 A PREMIUM 2019 B PREMIUM 2018 B PRO 2019 C FREE 2018 C PRO 2019 D FREE 2018 ...
CountIfs
Anonymous's avatar
Anonymous
Not applicable
6 years ago
Sorry, but in DAX THERE IS NO ORDER OF THE ROW. It's not Excel.

Best
D
ivandelgra's avatar
ivandelgra
Icon for Helper I rankHelper I
6 years ago

But Anonymous there is the possibility to add an index. Isnt't true? I'm reasoning in row context, but i don't know what formula enter in the calculated column.