Agreed, I mentioned it in the video. You can first split into columns, then unpivot. But that will also still give you multiple rows. That is why we count by Distinct. Unfortunately, I am yet to find any better & efficient way to go about this without getting multiple rows. For some reason, the multiple rows have nearly no impact on analysis as far as you count by Distinct. I am curious to know why stacking the data doesn't work for you.
@@MSurveyPoint I have a column 'Total Sales" - 10000, Country = "India,China, Japan". After creating multiple rows the sum(total Sales) is giving me 10000* 3 = 30000. Earlier it was just giving 10000 This is just an examoke
@@Rehan________________khan582 I understand your concern. But since you are adding to data model, the data will be stored in power query. Power query can handle as many rows there are unlike excel spreadsheet which has 1m rows limitation. Only the speed of the data processing may be affected subject to your PC's capability. Like in the video, I got 50k+ rows and still proceeded speedly. Check this video I explained this for Excel and possible precautions. ua-cam.com/video/WjmTNEmfJ2s/v-deo.html
Connect with me if you need support on the following: 1. Survey questionnaire design 2. Online survey scripting 3. Survey data Analysis 4. Research report writing 5. Data analysis in Excel 6. Survey Dashboard in Excel 7. Survey Dashboard in Power Bi Email: msurveypoint@gmail.com Book appointment here calendar.app.google/MMasAbZPDuwCCux76 The scope of my services includes but not limited to the areas of Market Research, Customer Experience Research, Product Research, User Experience Research, Employee Engagement Surveys, NPS, CSAT & Voice of the customer, Monitoring & Evaluation, etc.
Very helpful video! Thanks
Perfect explanation, Many Thanks
Muchas gracias, fue de mucha ayuda. ¡Un saludo!
Me alegro que esto haya ayudado
This video was very helpful for me, thank you very much!!!
Thank you for the feedback.
Happy to know this helps.
Kindly support my channel by sharing with your team.
Thank you
This creates multiple rows due to which the column which has numbers got added multiple times. Do you know any other way..?
Agreed, I mentioned it in the video. You can first split into columns, then unpivot.
But that will also still give you multiple rows. That is why we count by Distinct.
Unfortunately, I am yet to find any better & efficient way to go about this without getting multiple rows.
For some reason, the multiple rows have nearly no impact on analysis as far as you count by Distinct.
I am curious to know why stacking the data doesn't work for you.
@@MSurveyPoint I have a column 'Total Sales" - 10000, Country = "India,China, Japan". After creating multiple rows the sum(total Sales) is giving me 10000* 3 = 30000. Earlier it was just giving 10000
This is just an examoke
@@Rehan________________khan582
I understand your concern. But since you are adding to data model, the data will be stored in power query. Power query can handle as many rows there are unlike excel spreadsheet which has 1m rows limitation. Only the speed of the data processing may be affected subject to your PC's capability. Like in the video, I got 50k+ rows and still proceeded speedly.
Check this video I explained this for Excel and possible precautions.
ua-cam.com/video/WjmTNEmfJ2s/v-deo.html
@@MSurveyPoint how do I get the sum of column for distinct ID? In a measure?
Since the value column is numeric and you want total sales for each country:
You will use Show values as Average. to take care of the multiple rows.
Connect with me if you need support on the following:
1. Survey questionnaire design
2. Online survey scripting
3. Survey data Analysis
4. Research report writing
5. Data analysis in Excel
6. Survey Dashboard in Excel
7. Survey Dashboard in Power Bi
Email: msurveypoint@gmail.com
Book appointment here calendar.app.google/MMasAbZPDuwCCux76
The scope of my services includes but not limited to the areas of Market Research, Customer Experience Research, Product Research, User Experience Research, Employee Engagement Surveys, NPS, CSAT & Voice of the customer, Monitoring & Evaluation, etc.