Forum Discussion

WV's avatar
WV
Frequent Visitor
3 years ago
Solved

DAX - IF Field Time Matches specific value

Hi, I am trying to do an if statement in DAX. I want to say if the date is = 2018, then use this other calculation, else do another separate calculation. The data starts in 2018 and the rules ch...
Need Help
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    3 years ago

    Hi WV ,

     

    You need get one date value from the field first for year(). Try this:

     

    IF(Year(max(Master_TB_FC Detail'[Time Period])) = 2018, 
     
     

    Best Regards

    Community Support Team _ chenwu zhu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-chenwuz-msft's avatar
v-chenwuz-msft
Community Support
3 years ago

Hi WV ,

 

You need get one date value from the field first for year(). Try this:

 

IF(Year(max(Master_TB_FC Detail'[Time Period])) = 2018, 
 
 

Best Regards

Community Support Team _ chenwu zhu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.