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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
CamillaDiPassio
Frequent Visitor

Group multiple columns

Hello everyone, 
I have a problem with a set of data. I have three different columns and I would like to know for each Code per month the sum of the Alert. 
For example: for the code 9765 I have 3 alerts in January
This is the set of date: 

CodeAlertDate
9930105/01/2022
301973105/01/2022
9765110/01/2022
9765110/01/2022
9765110/01/2022
13447111/01/2022
21745112/01/2022
9776114/01/2022
9300119/01/2022
21745125/01/2022
9776125/01/2022
301973126/01/2022
4823127/01/2022
9851128/01/2022
9851128/01/2022
301973128/01/2022
9765102/02/2022
9765103/02/2022
301973104/02/2022
9765104/02/2022
10072104/02/2022
9851104/02/2022
18861107/02/2022
9765108/02/2022
9300108/02/2022
9851108/02/2022
9851110/02/2022
9851115/02/2022
9851115/02/2022
21745115/02/2022
302986116/02/2022
9300117/02/2022
301973121/02/2022
21732123/02/2022
9851125/02/2022
21732102/03/2022
5376104/03/2022
10109114/03/2022
4823115/03/2022
9300117/03/2022
9851117/03/2022
21732117/03/2022
21732117/03/2022
9300121/03/2022
21732122/03/2022
9300123/03/2022
301973125/03/2022
21745125/03/2022
9300129/03/2022
21745131/03/2022

 

Thank you for the support!!!

1 ACCEPTED SOLUTION
Greg_Deckler
Community Champion
Community Champion

@CamillaDiPassio 

  1. Create a Month column: Month = FORMAT([Date],"mmmm")
  2. Create a MonthSort column: MonthSort = MONTH([Date])
  3. Set Sort By for Month to be MonthSort
  4. Put Code in a Matrix visual (rows)
  5. Put Month in the Matrix visual (column)
  6. Put Alert in the Matrix visual (values, sum aggregation)


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

1 REPLY 1
Greg_Deckler
Community Champion
Community Champion

@CamillaDiPassio 

  1. Create a Month column: Month = FORMAT([Date],"mmmm")
  2. Create a MonthSort column: MonthSort = MONTH([Date])
  3. Set Sort By for Month to be MonthSort
  4. Put Code in a Matrix visual (rows)
  5. Put Month in the Matrix visual (column)
  6. Put Alert in the Matrix visual (values, sum aggregation)


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.