cancel
Showing results for 
Search instead for 
Did you mean: 
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
Super User
Super User

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
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors