Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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.
User | Count |
---|---|
106 | |
85 | |
81 | |
73 | |
71 |
User | Count |
---|---|
111 | |
102 | |
97 | |
74 | |
67 |