[SelectedMaxDate] and [SelectedMinDate] doesn't return consistent result in the Matrix

[Pline]

Hello Community, 

When I try to calculate formulas using [SelectedMaxDate] and [SelectedMinDate], I am experiencing inconsistent results depending on my rows in the matrix. See the Screenshot below. Any clues on what I'm doing wrong?
I would greatly appreciate any guidance on what might be causing this issue.

Thank you for much for your help!

[v-binbinyu-msft]

Hi @Pline ,

I'm a little confused about your needs, Could you please explain them further? It would be good to provide a screenshot of the results you are expecting and desensitized example data.

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_Binbin Yu