Support Formation DAX

Share

Explore

Support Formation DAX

Gestion des dates

DATESINPERIOD vs DATEBETWEEN

DATESINPERIOD(<dates>,<start_date>,<number_of_intervals>,<interval>)

Exemple (

Radacad⁠

)

Sales for the Last Rolling Year =

CALCULATE(

[SalesAmount],

DATESINPERIOD(

Sales[Order Date],

LASTDATE(Sales[Order Date]),

-1,

YEAR)

)

Sera plus souple :

DATESBETWEEN(<dates>,<start_date>,<end_date>)

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.