Forum Discussion

Mjolnir's avatar
Mjolnir
Icon for Helper I rankHelper I
2 years ago

Visual calculation - Subtract one value column with another

Hi,   I would like a column in the matrix below to display the difference between the red and blue marked value columns.  I want to subtract "Budget" with "Utfall" but it seems like visual calcula...
some_bih's avatar
some_bih
Icon for Community Champion rankCommunity Champion
2 years ago

Hi Mjolnir just put new columns, beside yours two, and provide calculation logic.

check link for example

Mjolnir's avatar
Mjolnir
Icon for Helper I rankHelper I
2 years ago

some_bih I am totaly new to Power BI, therefor - wondering if you mean adding new columns to the visual or the table and data used to generate the visual? I can't find any function adding columns to the visual. Did'nt manage to solve the issue using your example.

 

Both "Budget" and "Utfall" are recorded under the attribute "Scenario" and their values presented by another column "Belopp".