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.
I want to subtract the values from Column A and Column B
For example, for the first row, I would expect the New Column value to be the difference between 16.7 - 5.10, so I would expect a new value in New Column to be 11.6. The basic subtraction measures I've tried are giving results that make no sense to me. It's worth mentioning that Column B is Summed and Column A is not.
please help! Thanks!
Solved! Go to Solution.
solved this by using a Group By in the Transform Data. That seemed to fix up the calculations
solved this by using a Group By in the Transform Data. That seemed to fix up the calculations
Hi Jcoolen09,
Can you try the below measure?
That does not work
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
60 | |
57 |
User | Count |
---|---|
188 | |
111 | |
105 | |
78 | |
71 |