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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
jisler3
Regular Visitor

Combining/counting data by date in a matrix

Hello,
I have a dataset in Excel that is basically used for project management and it has many columns but I only need three. One date column is basically text and has values other than the date. There are two other columns that have a person's name in them. One is basically titled Leading, the other column, Supporting.

Dataset.PNG

 

When I create the visual, Power BI will not aggregate or count the values in both columns separately. In other words, the values in the Leading column seem to be duplicated instead of displaying separate counts for Support or Lead based on the name in the appropriate column in the dataset. It was displaying correctly but now I am missing something. Additionally, I need to create a measure to aggregate the total count for each person for each date and the total should be a third column under each date. Any help is appreciated.

 

Matrix.png

2 REPLIES 2
jisler3
Regular Visitor

Thank You for the response. I did try this but received the same results.

some_bih
Super User
Super User

Hi @jisler3 in Power Query, for column "Submission Deadline" change datatype to date, close and apply, in matrix put that column in rows not in column and check results. Hopet this help





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.