Forum Discussion

weilip1803's avatar
weilip1803
Frequent Visitor
10 years ago
Solved

Data modeling for power BI

Hi people, I have problem with data modeling and creating new tables on Power BI,   Firstly, I have a large data set that have company name as a column and another column Test which has values a b...
Need Help
Tutorial Requests
  • ankitpatira's avatar
    ankitpatira
    10 years ago

    weilip1803 If I understood you correctly, in power bi desktop go to query editor, right click your table and click duplicate, in duplicated table select column with values A B C D E, under Transform tab click Pivot Column, Advanced Options, Count All and this would give you a new table with columns A B C D E and count of their occurences.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

ankitpatira's avatar
ankitpatira
Icon for Community Champion rankCommunity Champion
10 years ago

weilip1803 If I understood you correctly, in power bi desktop go to query editor, right click your table and click duplicate, in duplicated table select column with values A B C D E, under Transform tab click Pivot Column, Advanced Options, Count All and this would give you a new table with columns A B C D E and count of their occurences.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

  • weilip1803's avatar
    weilip1803
    Frequent Visitor
    10 years ago

    Thanks so much for the solution