Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
So as you can see in the image, i have 3 measures: anzahl, preis, umsatz
for each I have a Budget and an actual ("Ist")
Now I want to calculate for EACH measure the actual minus the budget, so I know how much i am off my target.
Unfortunately, I only understand that you can calculate with measures, but not with the values inside of a field.
In my data, I have a field that shows either "ist" or "budget", and I am not sure how i can subtract one from the other.
Thank you a lot in advance!
Solved! Go to Solution.
Hi @josiasbr ,
I'd like to suggest you enter to query editor and do unpivot columns on your values fields to convert them as attribute and value.
Unpivot columns (Power Query)
After these steps, you can use attribute field as row, month, budget/list as column, value on value fields and write a measure to compare with current budget/list based current category group.
If you are confused on coding formula, please share some sample data for test.
Regards,
Xiaoxin Sheng
Hi @josiasbr ,
I'd like to suggest you enter to query editor and do unpivot columns on your values fields to convert them as attribute and value.
Unpivot columns (Power Query)
After these steps, you can use attribute field as row, month, budget/list as column, value on value fields and write a measure to compare with current budget/list based current category group.
If you are confused on coding formula, please share some sample data for test.
Regards,
Xiaoxin Sheng
User | Count |
---|---|
103 | |
90 | |
78 | |
72 | |
68 |
User | Count |
---|---|
108 | |
96 | |
95 | |
74 | |
71 |