Log In
Register
Home
November 27, 2020
Offline
Hi all,
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.
Example:
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
Offline
Hi MJ,
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.
Mynda
1 Guest(s)
