Forum Discussion
Multiple Variables in Column. Split or Keep?
Hello, I am new to using power BI. I'm having trouble with multiple variables in one column. My dataset below is for 100 companies. There are over 150 columns to use for analysis but some of ...
In my opinion, you should create a separate table for companies and the states they operate in most likely, split out the states column and unpivot so that you have something like:
CompanyA, OH
CompanyA, IN
CompanyA, WI
CompanyB, OH
...
I would also create a table of distinct companies. Your third table would be your fact table and would have all of the columns except the State column. Then, relate your distinct company table to your other two tables in the obvious way.