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.
Dear all,
I'm trying to find a way through but I'm quiet stuck right now.
I have a table with budget per month.
To get the data structured I used the unpivot function for the month columns, so I can now calculate numbers on my budget
The second table is the requisition table which provides the order in the fysical year.
I want to calculate sum(Budget[Budget] - sum(Requisition[]budget]) - by the budget ID to get the overview about when was my budget used and how many is left to date.
Problem is that with the unpivot function the budget ID is not unique anymore and the connection is many-to-many. I tried to put a bridge table in between but it does not work either (for my knowledge)
Can someone give me a hint? Is there a function available which i missed? All help is really appreciated.
Thank you and have a wonderfull weekend.
Solved! Go to Solution.
After a while of additional research and tesing I was able to fix it.
I added a few columns in my bridge table and filtered by the uniqe ID to sum up the values.
Can you share the pbix to see the structure of the data
Proud to be a Super User!
Thank you for the opportunity. Additionally I want to say the budget file is a handmade structure which could be changed. The other sources are reports which cannot be changed.
https://www.dropbox.com/s/yrii72uz8fxk4i9/Forum-Reducing-Data.pbix?dl=0
After a while of additional research and tesing I was able to fix it.
I added a few columns in my bridge table and filtered by the uniqe ID to sum up the values.
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 |
---|---|
183 | |
111 | |
105 | |
77 | |
70 |