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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Syndicate_Admin
Administrator
Administrator

Help with a measure

Hi guys, I'm a big newbie to Power BI, and I need help with a measure:

I need to subtract 2 measures, if the result it gives me is less than or equal to zero I need it to return 0, if the date is earlier than today's date I need to return zero, and if it is not fulfilled that I return the result of difference. If someone can help me, I would appreciate it.

Thanks a lot

3 REPLIES 3
Syndicate_Admin
Administrator
Administrator

Thanks for the answer but it has not worked for me gives me the following error:

Lorenz_0-1681751703892.png

Thank you

You're missing a closing bracket on line 5.

johncolley
Solution Sage
Solution Sage

Hi,

 

Subtract = 

VAR _ameasure = SELECTEDVALUE(A value)
VAR _bmeasure = SELECTEDVALUE(B value)
VAR _date = SELECTEDVALUE(date)
VAR _result = IF(_ameausre - _bmeasure <= 0, 0, IF(_date < TODAY(), 0, _ameasure - _bmeasure))

RETURN

_result

 

If this answer solves your problem please mark it as a solution!

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.