How to get data form transection selection

Fonlovedog207 , refer if this can help

Latest
https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0

https://amitchandak.medium.com/power-bi-get-the-sum-of-the-last-latest-value-of-a-category-f1c839ee884e

Hi Fonlovedog207 ,

Please try below steps:

1. below is my test table

Table:

2. create a new column with below dax formula

Column =
VAR cur_id = 'Table'[ID]
VAR max_date =
    MAXX ( 'Table', [Date] )
VAR _val =
    CALCULATE (
        MAX ( 'Table'[Status] ),
        FILTER ( 'Table', 'Table'[ID] = cur_id && 'Table'[Date] = max_date )
    )
RETURN
    _val

Please refer the attached .pbix file.

 

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.