Hello Pigment!
I am having an issue with a formula.
I have a dimension called 'MRR-D Invoice '. I want to create the column “latest_suscription_duration” which takes the same value as“subscription_duration” according to the max end date, and that, for each customer.
This is similar to a group by function in sql. Anyone knows how to do that ?
I tried this but it gave me weird results because I didn’t group by customer reference :
'MRR-D Invoice .'Subscription_duration'[BY max 'MRR-D Invoice '.'End_date' ]
PS : End_date is a dimension, Subscription_duration is an integer
Customer_reference | End_date | Subscription_duration | Latest _subsciption_duration |
Customer A | 24-Jan | 3 | 3 |
Customer A | 21-Jan | 12 | 3 |
Customer A | 23-Jan | 4 | 3 |
Customer B | 24-Feb | 12 | 12 |
Customer B | 23-Feb | 12 | 12 |