Forum Discussion
ivandelgra
Helper I
Helper IHow 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 ...
That's trivial then.
I would like to know for each year (from 2018 to 2019):
- how many FREE subscribers have changed their plan to PRO subscribers
- 0
- how many FREE subscribers have not changed their plan
- just count the people with FREE entries in the table
- how many FREE subscribers have changed their plan to PREMIUM subscribers
- 0
Best
D
ivandelgraHelper I
Helper IAnonymous Maybe I explain wrong. I’m sorry for the english. I intended if no one can change MANY TIMES the plan in the same year which would be the solution? That it is, if only one time a year you can change the plan what would you do?
Anyway, as regards to “ You can't do this because within a single year there's no way of telling the sequence of events in time “, if it can be useful, the chrononological order of the subscription/change come from the order of the row: the last subscription (or the last change) is the last row.
Anyway, as regards to “ You can't do this because within a single year there's no way of telling the sequence of events in time “, if it can be useful, the chrononological order of the subscription/change come from the order of the row: the last subscription (or the last change) is the last row.
- Sorry, but in DAX THERE IS NO ORDER OF THE ROW. It's not Excel.
Best
D- ivandelgra
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.