Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Thanks for the answer but it has not worked for me gives me the following error:
Thank you
You're missing a closing bracket on line 5.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |