Forum Discussion
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 da...
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.
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.