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))
az38's avatar
az38
Community Champion
6 years ago

knowparthshah 

how do you calculate [CurrentYear]? Is it measure or calculated column?

 

do not hesitate to give a kudo to useful posts and mark solutions as solution

  • knowparthshah's avatar
    knowparthshah
    Frequent Visitor
    6 years ago

    It is a measure 

     

    Year ( max ( Sales[Date]))