Dinamyc parameter send to filter data

Hi mcantos ,

Thanks for your clarification! You're absolutely right since Power BI doesn’t provide the report execution timestamp dynamically, the best workaround is to simulate that run date using a table like LastRefreshTable.

I created a column in my main table that compares the ModifiedDate (like your lastUpdateDate) with the latest run date from LastRefreshTable. Based on this, I calculated a "Status" column that flags whether the data is "New" (updated after the last run) or "Old".

I tested this setup, and the results correctly reflect what you described: records updated after the last simulated run date show as "New", and others as "Old".

This solution works perfectly for the need you explained. Let me know if you want to automate the refresh date or integrate this with Power Automate too.

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.