Forum Discussion

TaroGulati's avatar
TaroGulati
Helper III
4 years ago
Solved

If condition issue

Hello everyone,   I am having some difficulty of If condition result.   I have created this measure :  Value condition = var slicerdate = SELECTEDVALUE(Sheet2[Date]) var cal = IF(slicerdate ...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    TaroGulati , Try like

     

    Value condition = 
var slicerdate = maxx(ALLSELECTED(Sheet2), Sheet2[Date])
var cal = IF(slicerdate >TODAY(), sum(Sheet2[Value]),sum(Sheet2[Value +10]))
return  cal
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, TaroGulati ;

    Because your slicer is [month name] ,and your measure is SELECTEDVALUE(Sheet2[Date]) ; so it not right. you could modify the measure as follows:

    Value condition = 
var cal = IF(MONTH(SELECTEDVALUE('Sheet2'[month name])&" 1") >=MONTH(TODAY()), [Value Measure],[value +10 measure])
return cal

    The final output is shown below:

    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

misaki233's avatar
misaki233
Helper II
4 years ago

Hi TaroGulati 

 

You have used SELECTEDVALUE(Sheet2[Date]) to compare with TODAY(), but your slicer is limited by month. You could create a new measure with SELECTEDVALUE(Sheet2[Date]) and you will find it returns BLANK. 

 Your slicer needs to be accurate to days, or use months in conditions for comparison. It is also possible to get the maximum/minimum date of the selected month and compare it to today. Anyway, you need uniform units of comparison.