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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
CR7
Helper II
Helper II

how generate a calculated column with max date1 for each label

label     DATA1                  NEEDED COLUMN

A           01-01-2023          10-01-2023

A           05-01-2023          10-01-2023

A           10-01-2023          10-01-2023

B           03-01-2023           08-01-2023

B           08-01-2023           08-01-2023

 

how can i generate a calculated column (the  needed column) with max date1 for each label

 

1 ACCEPTED SOLUTION
Avantika-Thakur
Solution Supplier
Solution Supplier

Hi @CR7 ,

Can you try creating a DAX column with the below formula

Max date = calculate(MAX('Table'[Date]),ALLEXCEPT('Table','Table'[label]))
 
AvantikaThakur_0-1675083319734.png

 

 
Hope this helps!
 
Please accept the solution if this answers your query.
 
Thanks,
Avantika Thakur

View solution in original post

1 REPLY 1
Avantika-Thakur
Solution Supplier
Solution Supplier

Hi @CR7 ,

Can you try creating a DAX column with the below formula

Max date = calculate(MAX('Table'[Date]),ALLEXCEPT('Table','Table'[label]))
 
AvantikaThakur_0-1675083319734.png

 

 
Hope this helps!
 
Please accept the solution if this answers your query.
 
Thanks,
Avantika Thakur

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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