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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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)

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!:
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)

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

DAX is easy, CALCULATE makes DAX hard...

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.

Top Kudoed Authors