cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BlueWhite111
Post Patron
Post Patron

Calculated column - Max value based on two columns

Hi Experts

 

I am trying to work out the max value based on the Task ID and End Date as shown in the sample data below, need a calculated column and where we have the max value (new column) return expected result

 

Task IDEnd DateValue (£)Expected Result
102/03/20231010
103/03/202320 
203/03/20233030
213/03/20233535
304/04/20238 
311/04/202311 
325/04/20235555
1 ACCEPTED SOLUTION
Ahmedx
Solution Sage
Solution Sage

1 REPLY 1
Ahmedx
Solution Sage
Solution Sage

pls try this

Screen Capture #1165.png

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