November 27, 2020
I am new to this forum as well as to advanced excel. Trying to learn from your youtube videos which is very much useful.
I have the following issue:
I added 4 tables to powerpivot data model and created few measures. Now I want to create another measure which have to use already created measure.
I have created a measure for calculating chemical cost %
I have a column of budgeted chemical cost %
Now I want to create a measure for calculating variance between budget and actual cost.
Pls help how to create this new measure in power pivot. Thanks all.
July 16, 2010
Welcome to our forum!
A budget vs actual formula should be quite simple:
= SUM([budgeted chemical cost %]) - [actual chemical cost %]
However, this greatly depends on your model structure. If that doesn't help, you'll need to upload your file, or screenshots of your file or a sample file.