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 all,
I'm running into an issue trying to calculate a % variance from plan. Below is a picture of the raw % to plan and its formula, giving us correct values.
However, when we attempt to get variance (e.g. 7.3% instead of 107.3%) using the below formula, we lose row context and all locations are displayed, giving us a lot of -100%s.
Any workarounds?
Solved! Go to Solution.
HI @RMDNA
Does this get close?
DTD PL % = VAR myVariance = DIVIDE( [Daily Sales] , [Daily Sales Plan] , Blank()) RETURN IF(NOT ISBLANK(myVariance) , 1 - myVariance)
HI @RMDNA
Does this get close?
DTD PL % = VAR myVariance = DIVIDE( [Daily Sales] , [Daily Sales Plan] , Blank()) RETURN IF(NOT ISBLANK(myVariance) , 1 - myVariance)
Needed a small adjustment to handle +/- (changed "1 - myVariance" to "myVariance - 1") but otherwise it worked great. Thanks!
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |