Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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?
Solved! Go to Solution.
@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 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.
Thanks so much for the solution
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)
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
84 | |
69 | |
68 | |
39 | |
37 |