Forum Discussion
How to load data by Max date by default and will changes accordingly by user's date selection
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 ?
Hey Anonymous ,
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
1 Reply
Hey Anonymous ,
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