How to load data by Max date by default and will changes accordingly by user's date selection

[NISHA_S]

I have a table with data and the requirement is to load data by max  date when it will load for the first time, when the user will select another date , the table will load with that date.Is it possible ?

[selimovd · Accepted solution]

Hey @NISHA_S ,

yes, that is possible with dynamic M parameters:

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters

Be aware that the table then has to have a live connection to the database.

Otherwise you could think if a slicer would do the same combined with some DAX measures.

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic