Dinamyc parameter send to filter data

[mcantos]

Hello 

I have a request from a client who wants us to save the date the report was generated and then use it as a parameter for the next report execution to display the data that was updated before it. They want to remark on the newest data in the report. 

Do you have any suggestions that come close to this?

Thank you! 

[v-tejrama]

Hi @mcantos.,

Thanks for reaching out to the Microsoft fabric community forum.

To highlight newly added rows based on the last report refresh, a parameter is created in Power Query called LastRefreshDate and converted into a one-row table using:

=#table({"LastRefresh"}, {{LastRefreshDate}})

It's important to set the column data type to Date/Time to avoid type mismatch errors in DAX.

In the main data table, a calculated column can be added using:

Here is the DAX :

Status =
VAR LastRefresh = MAX(LastRefreshTable[LastRefresh])
RETURN IF(SalesData[ModifiedDate] > LastRefresh, "New", "Old")

This allows the report to dynamically flag which rows are new based on the refresh date, making it easier to track recently updated data.

Please find the attached pbix file for your reference.

If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.

Best Regards,
Tejaswi.
Community Support

[danextian]

Hi @mcantos 

Power BI does not store a historical copy of the data. What gets loaded into the model upon refresh is based on the latest available data. That is true even if you don't enable the load for a  query.  The historical data, thus, must exist somewhere.  You can run a query  against a dataset using Power Automate that generates a summary of the data or whatever kpis you want to track and automatically save that as a csv file in sharepoint folder and then use that folder as a data source. Please refer to this https://www.matthewdevaney.com/power-automate-run-a-query-against-a-power-bi-dataset/