topic Dax to calaculate same period (till same date ) last year in DAX Commands and Tips

Dax to calaculate same period (till same date ) last year

Dhrutivyasa-070 — Tue, 13 Feb 2024 07:07:25 GMT

as per image ,

in april sales is till 9th apr 2023 but in previous year it was till 30th april

i want to calculate if in selected year/month my store is working till 10 days only then calculate sum of only 10 days in last year same month .

thanks in advance

Re: Dax to calaculate same period (till same date ) last year

tharunkumarRTK — Tue, 13 Feb 2024 07:31:51 GMT

Dhrutivyasa-070 you can follow the below pattern

PY Sales = VAR MaxDate = EDATE(MAX(Sales [Date]), -12) VAR MinDate = EDATE(MIN( 'Calendar' [Date]), -12) VAR LYDates = DATESBETWEEN( 'Calendar' [Date], MinDate, MaxDate) RETURN CALCULATE ( [Total Sales], LYDates )

Please don't forget to accept my solution if it helps. Thanks

Tharun