Gallery
Support Formation DAX
Share
Explore
Gestion des dates

icon picker
Cumul (TotalYTD)

Évolutions entre mois par année
Table =
SUMMARIZECOLUMNS (
'Date'[Calendar Year Number],
'Date'[Month],
'Date'[Month Number],
"Sales PY", TOTALYTD ( Sales[Sales Amount], DATEADD ( 'Date'[Date], -1, YEAR ) ),
"Sales YTD", TOTALYTD ( Sales[Sales Amount], 'Date'[Date] ),
"% Evol",
VAR tpy =
TOTALYTD ( Sales[Sales Amount], DATEADD ( 'Date'[Date], -1, YEAR ) )
VAR tcy =
TOTALYTD ( Sales[Sales Amount], 'Date'[Date] )
RETURN
DIVIDE ( tcy - tpy, tpy )
Share
 
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.