Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

New Member

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

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!


Community Support
Community Support

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

Helpful resources

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors