Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
kdc02
Frequent Visitor

Creating a calculated summary table based on an existing table

Hi,

 

I have a raw table (that contains other columns aside from these two):

DateCategories
1/1/2023Category B
1/1/2023Category B
1/1/2023Category B
2/1/2023Category F
2/1/2023Category F
2/1/2023Category F
1/1/2023Category 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/2023103218401
2/1/202347235435

 

Thank you!

1 ACCEPTED SOLUTION
selvaskm
Frequent Visitor

Create measure Catcount = Count(Catecory)
Use matrix visual with
row = date
column = catecory
values  = Catcount

View solution in original post

1 REPLY 1
selvaskm
Frequent Visitor

Create measure Catcount = Count(Catecory)
Use matrix visual with
row = date
column = catecory
values  = Catcount

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.