cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CR7
Helper I
Helper I

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
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors