Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 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,
I have a raw table (that contains other columns aside from these two):
Date | Categories |
1/1/2023 | Category B |
1/1/2023 | Category B |
1/1/2023 | Category B |
2/1/2023 | Category F |
2/1/2023 | Category F |
2/1/2023 | Category F |
1/1/2023 | Category G |
Is it possible to create a new table that is a summary count of the raw table like this?
Date | Category A | Category B | Category C | Category D | Category E | Category F | Category G |
1/1/2023 | 10 | 3 | 21 | 8 | 4 | 0 | 1 |
2/1/2023 | 4 | 7 | 23 | 5 | 4 | 3 | 5 |
Thank you!
Solved! Go to Solution.
Create measure Catcount = Count(Catecory)
Use matrix visual with
row = date
column = catecory
values = Catcount
Create measure Catcount = Count(Catecory)
Use matrix visual with
row = date
column = catecory
values = Catcount
User | Count |
---|---|
123 | |
70 | |
67 | |
58 | |
53 |
User | Count |
---|---|
183 | |
92 | |
67 | |
62 | |
52 |