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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Super User
Super User

@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)

@ 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!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

1 REPLY 1
Greg_Deckler
Super User
Super User

@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)

@ 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!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors