Calculated field in pivot table based on power pivot

[amiroo]

hi guys
I have some tables and I need create pivot table from these tables. so I used powerpivot.
now I need some calculated fields. how can I add them to my pivot table?

 

[SyedUsman]

Create the relationships first & then Make a measure in the greyed out area in the power pivot window.

 

[amiroo]

Create the relationships first & then Make a measure in the greyed out area in the power pivot window.

thanks for reply but I'm new in powerpivot
would you please explain how to make a measure?

I created relations. is it correct?

 

[SyedUsman]

It would be simple if you Goto the Power Pivot Tab & click on Calculated Fields there & make the Field as done in normal Pivot tables. use the "[" to refer to a column in power pivot. Though you must know DAX to make complex calculated fields.

 

[amiroo]

It would be simple if you Goto the Power Pivot Tab & click on Calculated Fields there & make the Field as done in normal Pivot tables. use the "[" to refer to a column in power pivot. Though you must know DAX to make complex calculated fields.

thank you so much. solved