Forum Discussion

Bratone's avatar
Bratone
Helper I
3 years ago
Solved

Values depending on date comparison

Hello,   I have a situation where depending on the date, I need to take into account one value or another. More pricesely, when rating a person, if the date is > than his promotion date I need to t...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    Bratone , Try like

     

    Averagex(values(Date[Month Year]), calculate(IF(MAX(Calendar[Date])<[Promo_date],[Criteria 1,[Criteria 2])) )

     

     

     

amitchandak's avatar
amitchandak
Super User
3 years ago

Bratone , Try like

 

Averagex(values(Date[Month Year]), calculate(IF(MAX(Calendar[Date])<[Promo_date],[Criteria 1,[Criteria 2])) )

 

 

 

Bratone's avatar
Bratone
Helper I
3 years ago

Thank you so much for your fast answer, is working as it should now: