Forum

Notifications
Clear all

New measure

3 Posts
2 Users
0 Reactions
62 Views
(@raman)
Posts: 33
Trusted Member
Topic starter
 

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.

 
Posted : 28/11/2020 1:25 am
(@mynda)
Posts: 4762
Member Admin
 

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

 
Posted : 29/11/2020 12:19 am
(@raman)
Posts: 33
Trusted Member
Topic starter
 

Thank you Mynda.

 
Posted : 03/01/2021 11:21 pm
Share: