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.
Help! I am dividing the dollars by the qty, however the expense lines come up blank. Any idea what I am missing?
Test Qty = [Qty Actual] + [Qty Rest of the year]
- this is calculated with 6 months of actual and 6 months of forecast
Test Dollars = "Total Dollars"
Hi, @jnguyen21
According to the display in your table, the measure you wrote will not be calculated according to your logic.
If you want to get the correct result, please share how your [Test Qty] and [Test Dollars] are calculated? Then we can try to help you modify the code.
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.
Best Regards,
Community Support Team _ Janey
I would like divide each line so i thought it would be
648,899 / 12,935,936 = .05
1,568,319 / 12,935,936 = .12
but is only dividing the total line
How are your [Qty Actual] and [Qty Rest of the year] defined?
You're dividing by zero so DIVIDE returns a blank for these rows. You can add a third argument to divide to return something other than a blank when dividing by zero. E.g.
Test Qty / Dollars = DIVIDE ( [Test - Dollars], [Test Qty], 0 )
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
104 | |
93 | |
83 | |
64 |