Need one suggestion. In the raw data/source datasheet, I have one column for Birthday information in Date number format. Furthermore, Some data are missing and some cells are mentioned with non-number values (i.e "N/A", "Not update" etc.). Now the problem is when I add this Table into power pivot, Dates are stored as text. That's why I could not add any function. Can you please how to solve this?
Is there a way to do the same thing as a Vlookup function? So combine fields from different tables, e.g see what type of article each customer had ordered or these kind of info? Or is only possible to have aggregate measures like Total Sales per customers so measures like Sum, Count etc?
Really well explained -- so far I'd made use of the data model functionality for the efficiency of data storage (can process millions of rows of data effortlessly) but I hadn't understood how the relationships work -- it's going to simplify my queries significantly as I don't need to use clumsy conditionals to process data into a better form -- I can just effectively do a lookup by bringing other tables into my data model.
This is so satisfying. Please in a case where one will have to select 2000 customers out of 4 or 5 datasets with each rows upto 20,000 and column 10. Do I do the selection during the data cleaning stage or during the model selection? Thank you
Very useful power pivot we have facing problem filter wise sheet separated in Power Pivot data analyze tab in Pivot option Baton show report filter page not working in Power Pivot how to solve problem
Question, can you hold control and select each table, and then add them to the data module w/o having to select and add them individually? Thanks in advance!
I cannot give this video ENOUGH thumbs up!!! Thank you for explaining this the way you did. It made my life so much easier!
I keep getting an error code when i try to make a relationship between my tables, says there duplicates. so annoying
You are one smooth criminal on damn excels. So satisfying to watch. Thanks
Very insightful, but I know it will be very instructive and inspirational if you share your data so we, your students may follow. Thank you boss.
What do I do if there are duplicate values when trying to make relationships?
When I create a pivot table from power pivot it always shows up blank. How do I fix this?
Thank you so very much! Your explaination is super clear and easy to follow along.
The third of your video I watch I must subscribe this channel the now, best explanation ever!
do you need microsoft office subscription for adding data in powerpivot table
Need one suggestion. In the raw data/source datasheet, I have one column for Birthday information in Date number format. Furthermore, Some data are missing and some cells are mentioned with non-number values (i.e "N/A", "Not update" etc.). Now the problem is when I add this Table into power pivot, Dates are stored as text. That's why I could not add any function. Can you please how to solve this?
Loved it. Thanks.
Is there a way to do the same thing as a Vlookup function? So combine fields from different tables, e.g see what type of article each customer had ordered or these kind of info? Or is only possible to have aggregate measures like Total Sales per customers so measures like Sum, Count etc?
THANK YOU SO MUCH. NOW I KNOW HOW TO MAKE PIVOT TABLE RELATIONSHIPS
This was so good!! Excellent explanations!!!
Why practice excel sheet is missing?🙄
Really well explained -- so far I'd made use of the data model functionality for the efficiency of data storage (can process millions of rows of data effortlessly) but I hadn't understood how the relationships work -- it's going to simplify my queries significantly as I don't need to use clumsy conditionals to process data into a better form -- I can just effectively do a lookup by bringing other tables into my data model.
Great video!!! Tons of useful information in just to 10 mins. Thanks
So far, T H E B E S T video tutorial!
This is so satisfying. Please in a case where one will have to select 2000 customers out of 4 or 5 datasets with each rows upto 20,000 and column 10. Do I do the selection during the data cleaning stage or during the model selection? Thank you
Sounds like the cleaning stage - query only what you need, and append if necessary.
Very useful power pivot we have facing problem filter wise sheet separated in Power Pivot data analyze tab in Pivot option Baton show report filter page not working in Power Pivot how to solve problem
Awesome 👍😎😎😎😎👍👍👍 great job
Thank you❤
Question, can you hold control and select each table, and then add them to the data module w/o having to select and add them individually? Thanks in advance!
Can you send me the file, please?