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 c d e. And I want to create a new table with column A B C D e and count the total occurance that it has on the first table. How do i do that?

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.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

3 Replies

  • sdjensen's avatar
    sdjensen
    Icon for Solution Sage rankSolution Sage
    10 years ago

    Hi,

     

    Can't you just create a measure that count the rows in your table and then in a visual add column Test and your new measure?

     

    Count = COUNTROWS(Table)
  • 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.