cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper IV

## Get value from each group based on latest date

Hi How to get  Value for each Type based on max date from column End_Date

This should be 2 measure, because will use it in card visual separetely

Measure1_Open : value 3 , because max date from End_Date = 31 Mar 2022

Measure2_Closed : value 11, because max date from End_Date = 28 Feb 2022

Thank

1 ACCEPTED SOLUTION
Super User

Hi @Delion ,

I think standard CALCULATE should work. Something like:
Measure1_Open = CALCULATE(SUM('Table'[Value]),LATESTDATE('Table'[End_Date]),'Table'[Type]="Open")

The same logic applies for the second measure.

I wrote this on my  phone so if its not working, let me know and I will re-check from my pc.

### If my answer was helpful please give me a Kudos or even accept as a Solution.

3 REPLIES 3
Super User

Hi @Delion ,

I think standard CALCULATE should work. Something like:
Measure1_Open = CALCULATE(SUM('Table'[Value]),LATESTDATE('Table'[End_Date]),'Table'[Type]="Open")

The same logic applies for the second measure.

I wrote this on my  phone so if its not working, let me know and I will re-check from my pc.

### If my answer was helpful please give me a Kudos or even accept as a Solution.

Helper IV

It's solved, I modify it a bit

Measure1_Open = CALCULATE(SUM('Table'[Value]),LASTDATE('Table'[End_Date]),'Table'[Type]="Open")

Helper IV

hmm using LATESTDATE is not working, why use LATESTDATE not MAX?

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

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

#### Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

#### Fabric Community Update - September 2024

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

Top Solution Authors
Top Kudoed Authors