Calculated Column in Power Pivot (LOOKUPVALUE Vs RELATED)
HTML-код
- Опубликовано: 8 янв 2020
- #PowerPivot #DAX
Hello Friends,
In this video, you will learn how to use calculated column in Power Pivot Data Model. We have taken the example of Sales Data wherein we have product level Unit Sold and we have to add the Calculated column for revenue. To calculate the revenue we need the Price Per Unit on product level which we have in Product Master table. So first we have get the Price Per Unit in Sales Table. We have used LOOKUPVALUE and RELATED function of DAX.
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcelexpert.com/prod...
See our Excel Products:
www.pk-anexcelexpert.com/prod...
Visit to learn more:
Chart and Visualizations: www.pk-anexcelexpert.com/cate...
VBA Course: www.pk-anexcelexpert.com/vba/
Download useful Templates: www.pk-anexcelexpert.com/cate...
Dashboards: www.pk-anexcelexpert.com/exce...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
www.PK-AnExcelExpert.com
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/AAAAAE2OnviiEk5...
Pinterest:
/ pkanexcelexpert
************ Suggested Books ********
VBA: amzn.to/2TMMikX
Excel Dashboard: amzn.to/2WZi2Fj
Power Query: amzn.to/2Ibd7xR
Power Pivot and Power BI: amzn.to/2DCg8BB
Exam Ref 70-778 (Power BI): amzn.to/2GnWYTN
************ My Stuff ***************
Mic : amzn.to/2TLnF88
Video Editor: screencast-o-matic.com/refer/...
Its all i need! Thanks from Brazil!
Thanks for your valuable feedback
Thanks, you made my day!!! Perfect!
I'm so glad!
excellent explanation, very clear and simple
Thanks for your valuable feedback
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
Thanks for your valuable feedback
Hoping for a simple example of adding values of two existing columns..but aapko to txt se import karke demo karna hai
Perfect 👌🏻
Thanks for your valuable feedback
Merci
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?
Very good, by the way, has the spreadsheet used for download. Thank you.
Thanks for your valuable feedback. Excel download link has been given in videos discretion box. Please download this excel file from there.
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..
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.
I will waiting Sir,
You are my online teacher
Always nice post.
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!
Hello PK do you any solution to unpivot calculated columns????
Create a Calculated column
5:03
You're welcome