Forum Discussion

knowparthshah's avatar
knowparthshah
Frequent Visitor
6 years ago
Solved

Using CALCULATE with variable

When I write this measure,   Amt CYPY = VAR py = 2019 RETURN CALCULATE ( [Amt], YEAR(Sales[Date]) >= py )   the table shows values for only years greater than 2019 ( and empty against ot...
  • Parkavi's avatar
    Parkavi
    6 years ago

    knowparthshah  Please make sure you have used the below DAX measure for [CurrentYear], which will return the max year in the table irrespective of any filters applied

     

    CurrentYear = 

    CALCULATE(YEAR(MAX(Sales[Date])),ALL(Sales))
Parkavi's avatar
Parkavi
Frequent Visitor
6 years ago

knowparthshah  Please make sure you have used the below DAX measure for [CurrentYear], which will return the max year in the table irrespective of any filters applied

 

CurrentYear = 

CALCULATE(YEAR(MAX(Sales[Date])),ALL(Sales))
  • knowparthshah's avatar
    knowparthshah
    Frequent Visitor
    6 years ago

    Thanks a lot, It worked