DAX to permanently remove rows past data retention policy of 60 days

[beeisabelm]

How can I create a DAX to remove the rows from the table to comply with the data retentino policy of 60 days? I have been refreshing a CSV file with weekly new data and would like to run a function to remove all data order than 60 days. I found some references to create new table with rows removed, but that's not applicable.

[ImkeF]

Hi

you can set a "relative date filter" in the query editor like so:

then apply the filter like so:

[beeisabelm]

@ImkeF I need to PERMANENTLY DELETE old data, not just filtering them out from the view. Thanks!

[ImkeF]

Just to make sure my understanding is correct: You want to delete rows in the underlying csv files that you're importing with Power BI?

That's not possible with native Power BI. You'd have to use Python- or R-scripts (from Power Query) for that.

[Greg_Deckler]

You can't really do that in DAX, you would want to use power query. @ImkeF should be able to help you.