Skip to main content
Sign In |
  Help (new window)

PowerPivotPro's FAQ Site

Go Search
  
PowerPivotPro's FAQ Site > The Great PowerPivot FAQ > Can I calculate a field in Table1 times a field in Table2?  

The Great PowerPivot FAQ: Can I calculate a field in Table1 times a field in Table2?

Title

 Can I calculate a field in Table1 times a field in Table2? 

Answer
In the PowerPivot window, add a new calculated column.
 
If you want to multiply Sales in the Fact table by Rate in the Bonus table, you have to use:
=Fact[Sales]*Related(Bonus[Rate])
 
If you leave out the Related function, you will get an error. 

Client/Server

 Client 

Topic

 F - Calculations (DAX) 

Purpose

 Information 

Answered?

 Yes 

Contributor

 Bill Jelen 

Título

  

Resposta
 

Frage

  

Antwort
 

preRTM

  
Attachments
Created at 1/14/2010 9:17 AM  by Bill Jelen 
Last modified at 1/14/2010 9:17 AM  by Bill Jelen