The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
101 | |
95 | |
80 | |
62 | |
56 |
User | Count |
---|---|
252 | |
121 | |
112 | |
81 | |
70 |