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.
@aniaaaaaa152 ай бұрын
Very helpful video! Thanks
@danielstevenvargas67538 ай бұрын
Muchas gracias, fue de mucha ayuda. ¡Un saludo!
@MSurveyPoint8 ай бұрын
Me alegro que esto haya ayudado
@zephirosl80737 ай бұрын
This video was very helpful for me, thank you very much!!!
@MSurveyPoint7 ай бұрын
Thank you for the feedback. Happy to know this helps. Kindly support my channel by sharing with your team. Thank you
@Rehan________________khan5825 ай бұрын
This creates multiple rows due to which the column which has numbers got added multiple times. Do you know any other way..?
@MSurveyPoint5 ай бұрын
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________________khan5825 ай бұрын
@@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
@MSurveyPoint5 ай бұрын
@@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. kzfaq.info/get/bejne/jdCdh7F20syuYqc.html
@Rehan________________khan5825 ай бұрын
@@MSurveyPoint how do I get the sum of column for distinct ID? In a measure?
@MSurveyPoint5 ай бұрын
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.