Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello everyone,
I am having some difficulty of If condition result.
I have created this measure :
Solved! Go to Solution.
@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
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.
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.
@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
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.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |