Forum Discussion

Anonymous

Not applicable

4 years ago

Solved

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

Migasuke
4 years ago
Hi Anonymous ,

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.

3 Replies

Migasuke
Memorable Member
4 years ago
Hi Anonymous ,

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.
- Anonymous
  Not applicable
  4 years ago
  Migasuke
  
  It's solved, I modify it a bit
  Measure1_Open = CALCULATE(SUM('Table'[Value]),LASTDATE('Table'[End_Date]),'Table'[Type]="Open")
- Anonymous
  Not applicable
  4 years ago
  Migasuke
  
  hmm using LATESTDATE is not working, why use LATESTDATE not MAX?