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,
i have data like this in my report,
and i need to write DAX/IF statement in power bi, which is similar to below formula.
if(([OVER]+[LOW]+[RIGHT]) <> 0) then ([RIGHT]/([OVER]+[LOW]+[RIGHT])) else null AS CORRECTSTOCK
(this formula i used in cognos)
Is it possible to write a formula like this in power bi? (result should be same as cognos formula)
Thanks in Advance.
Solved! Go to Solution.
You can try this measure
Measure= VAR __Over= SUM( table[over]) VAR __LOW = SUM( table[low]) VAR __Right = SUM( table[right]) VAR __TotalOLR = __Over+__LOW+__Right VAR __IfTrue = DIVIDE( __RIGHT, __TotalOLR VAR __IfFalse= SUM ( table[CorrectStock]) RETURN IF( __TotalOLR <> 0, __IfTrue, __IfFalse )
You can try this measure
Measure= VAR __Over= SUM( table[over]) VAR __LOW = SUM( table[low]) VAR __Right = SUM( table[right]) VAR __TotalOLR = __Over+__LOW+__Right VAR __IfTrue = DIVIDE( __RIGHT, __TotalOLR VAR __IfFalse= SUM ( table[CorrectStock]) RETURN IF( __TotalOLR <> 0, __IfTrue, __IfFalse )
Thank you so much.
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 |
---|---|
47 | |
26 | |
22 | |
12 | |
8 |
User | Count |
---|---|
76 | |
50 | |
46 | |
16 | |
12 |