Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
TaroGulati
Helper II
Helper II

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 >=TODAY(), [Value Measure],[value +10 measure])
return cal
 
i am trying to present if selected month is less then today then "value +10 measure" other wise "value measure".

Value Measure = SUM(Sheet2[Value])
 
value +10 measure = SUM(Sheet2[Value +10])
 
 
results are not as per value condition measure. 
 
PBI file is on this link:
 
I am missing something in the if expression?
 
thanks in advance for any suggestion. 
2 ACCEPTED SOLUTIONS
amitchandak
Super User
Super User

@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

View solution in original post

v-yalanwu-msft
Community Support
Community Support

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:

vyalanwumsft_0-1632115731804.pngvyalanwumsft_1-1632115750650.png

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.

View solution in original post

3 REPLIES 3
v-yalanwu-msft
Community Support
Community Support

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:

vyalanwumsft_0-1632115731804.pngvyalanwumsft_1-1632115750650.png

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.

amitchandak
Super User
Super User

@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
misaki233
Helper II
Helper II

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.

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.