time intelligence problem, need a dax help

[Memorphix]

Hi, a time intelligence problem. Suppose i have 3 year data: 2021 2020 and 2019 Now I have all 12 months data in 2019, 2020 but only 3 months data in 2021. Indian fiscal year = April (start), March (end)

I need a dax for: When I do the previous year calculation, suppose for 2021, then it gives me only 3 months of 2020 data (as i have only april may jun data in 2021), but when I do previous year calculations for 2020, it gives me all 2019 data (as I have all months data in 2020). Please help?

[ray_ux · Accepted solution]

You need to use a proper filter rather than the PREVIOUSYEAR() function

CALCULATE(
  [YourMeasure]
  ,FILTER(
      ALL('DimDate')
      ,'DimDate'[Year] = MAX('DimDate'[Year])
        )
  )