Perfect explanation, Many Thanks

Very helpful video! Thanks

Muchas gracias, fue de mucha ayuda. ¡Un saludo!

@MSurveyPoint

7 ай бұрын

Me alegro que esto haya ayudado

This video was very helpful for me, thank you very much!!!

@MSurveyPoint

6 ай бұрын

Thank you for the feedback. Happy to know this helps. Kindly support my channel by sharing with your team. Thank you

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.

This creates multiple rows due to which the column which has numbers got added multiple times. Do you know any other way..?

@MSurveyPoint

4 ай бұрын

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.

@Rehan________________khan582

4 ай бұрын

​@@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

@MSurveyPoint

4 ай бұрын

@@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. kzread.info/dash/bejne/iZ6htrB-ncmwYtY.html

@Rehan________________khan582

4 ай бұрын

@@MSurveyPoint how do I get the sum of column for distinct ID? In a measure?

@MSurveyPoint

4 ай бұрын

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.