Support Formation DAX

Pages

Gestion des dates

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 )

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.