Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Outdated product - DAX Measure

Hello,  Basic information:  In "Green" calculation we had the change and it means: All Product > TODAY   I have an issue with measure because the measure is counting values incorrectly. I w...
Need Help
  • sevenhills's avatar
    sevenhills
    3 years ago

    I think your calculation does not consider "diff = 0" scenario. See if the below works:

     

    Measure 2 = 
var cur_yearly_review=SELECTEDVALUE('Table'[Yearly review])
var cur_date=TODAY()
var diff=DATEDIFF(cur_yearly_review,cur_date,MONTH)
-- return diff
return 
SWITCH(TRUE(),
       diff > 6, "More than 6 months",
       diff >= 0, "Less than 6 months",
       diff < 0, "All recertified")

     

     

sevenhills's avatar
sevenhills
Super User
3 years ago

I think your calculation does not consider "diff = 0" scenario. See if the below works:

 

Measure 2 = 
var cur_yearly_review=SELECTEDVALUE('Table'[Yearly review])
var cur_date=TODAY()
var diff=DATEDIFF(cur_yearly_review,cur_date,MONTH)
-- return diff
return 
SWITCH(TRUE(),
       diff > 6, "More than 6 months",
       diff >= 0, "Less than 6 months",
       diff < 0, "All recertified")