Forum Discussion

MVenables's avatar
MVenables
Icon for Advocate II rankAdvocate II
2 years ago

Efficient Prior Year DAX Calculation needed please

Hi All,   Within the business our Financial Year starts 1st May each year so for example this current week is Year Week 202401 (the year & the week number). To calculate anything for prior year, we...
"DAX help"
aduguid's avatar
aduguid
Icon for Memorable Member rankMemorable Member
2 years ago

 

 

Count Of Products Prior Year = 
VAR _fiscal_year =       YEAR(EDATE( _today_date, 5))
VAR _fiscal_year_start = DATE ( _fiscal_year - 1, 05, 01)
VAR _fiscal_year_end =   DATE ( _fiscal_year, 04, 30)

RETURN
CALCULATE(
    [Count Of Products],
    DATESBETWEEN('Calendar'[Date], _fiscal_year_start, _fiscal_year_end)
)