Add a new column power bi desktop

[Anonymous]

Hello Community,

I need please your help.

I have a one table and i want to add a new column in power bi.

The new column's formula named MP Plan = ($mt Plan-$mt Actual) but i want 100-200 (because i'm intested only by the Plan Column and not Actual).

Thank you so much,

[amitchandak]

Create a measure( Not column) Sum($mt_plan) - Sum($mt_actual) .

[Anonymous]

Thank you for your answer.

I need a new column.

1- New column formula :

if (Scenario=Plan) then MP Diff = $mt Actual-$mt Plan (100-200=-100)

2- After i will use this formula to calculate another new column :

if (Scenario=Plan) then MP Diff Plan = MP Diff * Amount (-100*40=-400)

@amitchandak wrote:

Create a measure( Not column) Sum($mt_plan) - Sum($mt_actual) .

[v-diye-msft]

Hi @Anonymous 

I'm not very clear about your request:

1- New column formula :

if (Scenario=Plan) then MP Diff = $mt Actual-$mt Plan (100-200=-100)

when Scenario=Plan it should be 0-200=-200 why -100?

2, if (Scenario=Plan) then MP Diff Plan = MP Diff * Amount (-100*40=-400)

shouldn't be -4000?

3. where's the Amount column in your second capture? please kindly complete it.

[amitchandak]

You can create a pivot table -https://radacad.com/pivot-and-unpivot-with-power-bi

Or Summarize table - https://docs.microsoft.com/en-us/dax/summarize-function-dax