Thanks for the video. Question though, why not selecting "add this data to data model" straightforward when creating the pivot? Is there a need to delete the first pivot table before it works?
Great Video. Concise and clear you have mastered conveying complex functionality of Excel using simplified real world problems in record time. Great Job! So glad I found you last year. :-)
Thank you Chris, much appreciated with your easy explanations, tone and jokes. You are a legend. I started using 365 but couldn't get the distinct count. By the way have you entered your name for the Welcome 2023 Excel Expo Championships Las Vegas? lol lol ...something that keeps on my feed....God bless.
@@ChrisMenardTrainingglad found you today Chris. I have a cancellation sales of 2, my pivot table doesn’t show -2 if I use ‘count’ instead of ‘sum’. How do I show-2 in pivot table if the total unit sold are in product items like phone, tablet, monitor, keyboard? What’s the different between power query and power BI?
Thanks. Problem here: I have a column with some empty cells (unknown) in it. Distinct count sees blanks as one distinct value, so it adds 1 to my result of distinct values. So, is there a way to count distinct values and skip empty cells???
Hey There! Thanks for the quick video. Quick question though... Prior to right clicking and selecting distinct count on the pivot table I do not have a blank row but after I select distinct count it adds a Blank and has a count of 1. There is nothing in my data that is blank and I can't figure out how to clear it out since it is affecting my overall total.
Thanks Chris, this was perfect. I couldn't figure out why the "distinct count" wasn't showing!! I'm still a bit confused why they needed a checkbox to make the "Add this data to the Data Model" optional?? Any idea why?
Hi, I have two columns, student IDs and courses names. Each student opted five courses. Mean both Columns are multiple values. How can we separate first distinct unique, second, third and more. Requested to kindly help me. Thanks a lot.
Hello, after adding the data to Data Model, i am not able to do sum of order total... It says we cant summarize this field with sum because it's not supported for calculations for text data types.. please help
Hi, after adding the 'data model' to the dynamic to perform the distinct count, the table no longer updates the data, an error always appears, saying that "it was not possible to update the data model of its source data". Do you know how to solve it?
Awesome, Chris! Thanks - I always search out your videos when I have a reallive business data problem to solve. I appreciate the short, on point video
Thanks, Scott! I appreciate it.
Thank you very much - no messing around and straight to the point!
Thank you!
Thanks for the video. Question though, why not selecting "add this data to data model" straightforward when creating the pivot? Is there a need to delete the first pivot table before it works?
Crisp, clear and concise. But not too concise - It was like having a buddy explain something to me. Thanks
You are welcome. I haven't heard that before but I like it... a buddy explaining something to me.
Great Video. Concise and clear you have mastered conveying complex functionality of Excel using simplified real world problems in record time. Great Job! So glad I found you last year. :-)
Celeste, thank you. I appreciate the wonderful comment.
Thank you. This saved the day.
You're welcome!
Big thanks Chris! You saved my life!
You are welcome!
Thank you, Chris. I was looking for this, your vide saved my time, instead of using complex formulas
You're welcome!
Thank you! Was looking for this for a week now
Glad I could help!
Wow,,, you really made my day Chris! So much hours saved here! Thanks a lot!!!
You are welcome!
You're a life saver brother 😂
Not sure about that, but thank you! :-)
This was fantastic!!!! Thank YOU!! @Chris Menard
Glad to help.
Very Useful, Thank you Chris.
You're welcome!
Thank Chris for your share this great tip.
You bet!
Mucu appreciated. I was searching for the answer and i saw the video. I love u man. Thanks❤
No problem 👍
@@ChrisMenardTraining any suggestions on power automation ?
You are a genius! Thank you!
Thanks, it helps me a lot ❤
You're welcome 😊
great Video.. right straight to the point! Thank you
You're welcome. Thanks, Patricia.
Great Video, Chris
Thanks 👍
Exactly what I needed! Thanks!
This what am looking for.. Thanks for sharing.
My pleasure
this is an awesome video! Very helpful
thanks man
can't get any easier than this
Happy to help
Thank you Chris, much appreciated with your easy explanations, tone and jokes. You are a legend. I started using 365 but couldn't get the distinct count. By the way have you entered your name for the Welcome 2023 Excel Expo Championships Las Vegas? lol lol ...something that keeps on my feed....God bless.
Excellent - thank you!
You are welcome!
You made it so easy. Thanks
You're welcome!
I love the data model and power pivot, there is just so much you can do with them especially if you learn a little DAX.
You are correct! Thanks, Roy.
@@ChrisMenardTrainingglad found you today Chris. I have a cancellation sales of 2, my pivot table doesn’t show -2 if I use ‘count’ instead of ‘sum’. How do I show-2 in pivot table if the total unit sold are in product items like phone, tablet, monitor, keyboard?
What’s the different between power query and power BI?
this method worked.. awesome
Glad it helped
Awesome! Thank you!
You are so welcome!
Thanks a lot! You got a subscriber
Thanks for the sub!
Thank you very much
You are welcome
Yes you hoped well, i liked it.
Great video 🎉
Thank you 😁
YESS! Thank you!
Glad to help. Thanks, Glen.
Thank you! 🙏🏻
No problem 😊
Great help. TKS
Thank you
thank Bro
Welcome
thank you
thankyouuu ❤
I am using mac machine and I don't see checkbox o select -add this datato the Data Model. how to bring that checkbo during pivote table creation.
Very helpful Chris! Although i dont understand why Microsoft wont just make this a default. An extra step for no reason.
Thank you.
Thanks. Problem here: I have a column with some empty cells (unknown) in it. Distinct count sees blanks as one distinct value, so it adds 1 to my result of distinct values. So, is there a way to count distinct values and skip empty cells???
I need for MacOS :( Thank you for your video!
Hi there! I'm using corporare account on excel. I don't see "add data to the data model" option. I don't see "power pivot" as well :/
Same problem
Did you get any solution?
Hey There! Thanks for the quick video. Quick question though... Prior to right clicking and selecting distinct count on the pivot table I do not have a blank row but after I select distinct count it adds a Blank and has a count of 1. There is nothing in my data that is blank and I can't figure out how to clear it out since it is affecting my overall total.
❤😅 thank
Welcome.
That's Awsomeeeee
Thank you!
Any tips to refresh the power pivot with new data? When I click refresh it changes back to the blank pivot template.
Is this not available for Mac? Cannot find the check-box here.
Thanks Chris, this was perfect. I couldn't figure out why the "distinct count" wasn't showing!! I'm still a bit confused why they needed a checkbox to make the "Add this data to the Data Model" optional?? Any idea why?
When i use the distinct count, another row is now unable to "sum" even though it is a row of numbers. Can you help with this?
I cant find this option in online SharePoint excel. Any workaround ??
How could I make the sum of the values give me what the counts actually add up to?
Hi, I have two columns, student IDs and courses names. Each student opted five courses. Mean both Columns are multiple values. How can we separate first distinct unique, second, third and more. Requested to kindly help me. Thanks a lot.
Unfortunately if you are using Microsoft 365, you don't get an option to "add to data model" and it is very frustrating!
I made the video using Microsoft 365.
@@ChrisMenardTraining where is this? I cannot find it on your channel.
Hello, after adding the data to Data Model, i am not able to do sum of order total... It says we cant summarize this field with sum because it's not supported for calculations for text data types.. please help
Hlo sir... Great video...but I need your help as I am doing a Data Analytics course ..and I am facing some issues in case study
Hi, after adding the 'data model' to the dynamic to perform the distinct count, the table no longer updates the data, an error always appears, saying that "it was not possible to update the data model of its source data". Do you know how to solve it?
when I select distinct count, my data all shows 1 for each cell. What am I doing wrong?
Add this data option is deactivated 😢
How come when you count each date the total is 17 but the grand total shows 9 unique customers?
How in wps office?
Data model option doesnt pop up for mac excel v 16.77.1
yes. What can we do to get a distinct count?
@@harshini.bhesettyharshu3595 Buy a windows pc.
Thanks for saving my ass
You are welcome.
EXACTLY what I needed Thanks!!!