Max Date Check

Hi poojag820 ,

Thanks for bhanu_gautam's reply!

And poojag820 , please try this way:
Not sure if your data looks like this, this is my test data:

Use this DAX to create a measure:

Flag = 
VAR _Date = 
CALCULATE(
    MAX('Table'[Date]),
    ALL('Table'),
    'Table'[Value] <> BLANK()
)
RETURN
IF(
    MONTH(MAX('Table'[Date])) = MONTH(_Date) && YEAR(MAX('Table'[Date])) = YEAR(_Date),
    1,
    0
)

Then all rows corresponding to the largest month in the table where Value exists will be marked as 1, and the others as 0.

You can then filter to show only data with measure=1.

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.