Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello Experts,
I am facing an issue while using the simple Divide fuction. Some of the rows returns correct results while some returns incorrect results as shown in the below screenshot.. I have also tried in other ways by using variables but no luck. Kindly help me out of it.
Regards,
Ajay Emmadi
Solved! Go to Solution.
Give this a try, see if it works.
MAP Value =
DIVIDE (
ROUND ( SUM ( 'Planning Dashboard'[Closing StockValue] ), 2 ),
ROUND ( SUM ( 'Planning Dashboard'[Closing Stock] ), 2 ),
0
)
Give this a try, see if it works.
MAP Value =
DIVIDE (
ROUND ( SUM ( 'Planning Dashboard'[Closing StockValue] ), 2 ),
ROUND ( SUM ( 'Planning Dashboard'[Closing Stock] ), 2 ),
0
)
I am betting that the ones that look like wrong actually have a very small number after the decimal so it is not 0, it is 0.0000056 or something like that.
User | Count |
---|---|
86 | |
82 | |
68 | |
64 | |
55 |
User | Count |
---|---|
120 | |
99 | |
91 | |
83 | |
65 |