Forum Discussion

Memorphix's avatar
Memorphix
New Member
4 years ago
Solved

time intelligence problem, need a dax help

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 (...
Help me please
  • RayWu's avatar
    RayWu
    4 years ago

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

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

     

RayWu's avatar
RayWu
Icon for Memorable Member rankMemorable Member
4 years ago

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

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