Hello ,
I want to calculate a sum of mesure based on data from the previous Year (N-1)
expression to calculate my mesure on Year N :
If(PERIODE='MTD',Sum({<[Date_Commande.autoCalendar.Date]={"$(=Max(Date_Commande.autoCalendar.Date))"}>}[Actuals MTD Année N]),
Sum({<[Date_Commande.autoCalendar.Date]={"$(=Max(Date_Commande.autoCalendar.Date))"}>}[Actuals YTD Année N])
)
I have 2 fields :
[Mois/Année] : give me Month+year (example 03/2020)
[Mois/Année Daily-1] : give me Month+year N-1 (example 03/2029)
Thanks