Power BI Newbie here - how do I subtract a column from another?

[josiasbr]

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!

[Anonymous · Accepted 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