New % complete column/ measure required to look at 2 columns( planned v actual)

[RickSmalls83]

Hi, 

I want to create a calculation that shows the below right sided columns as actual amounts complete against the Scope/ Planned data in the left side column;

As preference i would like to do this in Power BI and ont in the excel source data.

Thanks,

Rick

[RickSmalls83]

know how i can ' minus' the difference between to columns? I want to a measure or column that shows the variance between to columns...

Thanks,

Rick

[v-jingzhang · Accepted solution]

Hi @RickSmalls83 

You can create a measure with the following DAX. 

New % complete = DIVIDE(SUM('TableName'[Actual amount]),SUM('TableName'[Planned Amount]))

Or create a calculated column in the original table with the following DAX. 

New % complete = DIVIDE('TableName'[Actual amount],'TableName'[Planned Amount])

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.