Forum Discussion

Caitlin_Knox's avatar
Caitlin_Knox
Icon for Advocate III rankAdvocate III
9 years ago
Solved

Data modeling question

I'm hoping someone can at least point me in the right direction to do more research. I have a field in my data set that technically a single line text, but has multiple values separated by commas. Ho...
Need Help
Show and Tell
  • Sean's avatar
    Sean
    9 years ago

    Caitlin_Knox  Let me know if you have any questions...

     

    Hope this helps! :smileyhappy:

     

     

Caitlin_Knox's avatar
Caitlin_Knox
Icon for Advocate III rankAdvocate III
9 years ago

Sean I think I did this right. I don't know how to do it in PBI Desktop, so I just created a table in Excel. I didn't see an attach file option, so I just pasted it here.

 

IDProviderQuoted
1Cox, CenturyLink, Level3
2Cox
3AT&T, Level3
4Wow!, CenturyLink
5inContact, AT&T
Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
9 years ago

Caitlin_Knox  Let me know if you have any questions...

 

Hope this helps! :smileyhappy:

 

 

  • Caitlin_Knox's avatar
    Caitlin_Knox
    Icon for Advocate III rankAdvocate III
    9 years ago

    Sean THANK YOU SO MUCH. This was so easy to follow along, and worked perfect.

  • Bokazoit's avatar
    Bokazoit
    Icon for Post Prodigy rankPost Prodigy
    4 years ago

    What if I need the count to add up all the time?

    Lets say there are 400 respondents, but for a question, only 300 have answered. If I show the result some people would start arguing that there is something wrong with the data since it is missing 100 respondents. 

    I would say, they are not missing they did not answer the question. But if I wants it to add up to 400, showing the 100 respondents as 'Did not respond' in the legend. How to do that?