Support Formation DAX

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 )