Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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.
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
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.
User | Count |
---|---|
92 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |