Calculated Column in Power Pivot (LOOKUPVALUE Vs RELATED)

[@nubiadeandrade6253]

Its all i need! Thanks from Brazil!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@chavelooo33]

excellent explanation, very clear and simple

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@andersborgstrom2634]

Thanks, you made my day!!! Perfect!

[@PKAnExcelExpert]

I'm so glad!

[@lukev730]

PK, thank you so much Very nice learning Amazing teaching Please make series of topics in power pivot Your videos are so helpful in our work life. Thank you again

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@huzumcarmen]

hello, I have a question related to power pivot. It is possible to have a grand total in a pivot table summarising a few columns from two spreadsheets with relationships?

[@arindambhattacharya7848]

Hoping for a simple example of adding values of two existing columns..but aapko to txt se import karke demo karna hai

[@rickymarwa6769]

I'm from Indonesia I like your Chanel. I have question, If the price change, how about the privious data, because I think the price also change, Please advice..

[@PKAnExcelExpert]

Hi Ricky, Thanks for your question. This is a simple example. In your scenario price effective date will come in picture. Will create another video for this scenario.

[@rickymarwa6769]

I will waiting Sir, You are my online teacher Always nice post.

[@naveenmarapaka1278]

Hello PK do you any solution to unpivot calculated columns????

[@Luciano_mp]

Very good, by the way, has the spreadsheet used for download. Thank you.

[@PKAnExcelExpert]

Thanks for your valuable feedback. Excel download link has been given in videos discretion box. Please download this excel file from there.

[@NHHT777]

Can you please edit & make the formula based on 2 conditions: =LOOKUPVALUE('Product Master'[Price per unit],[Product],[Product]). Showing results based on two or more columns, say the results of: Product AND Order ID?This as always Awesome, thank you. Thank you very much in advance!

[@Tat-cx1lr]

Merci

[@shoryaarora1464]

Perfect 👌🏻

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@bernardb.4788]

Create a Calculated column 5:03 You're welcome