I want to make sure there are only 90 days of data in my Azure Analysis Services (AAS) model.
I'm thinking about using Power Query/M to only filter the most recent 90 days and then doing a Process Full. Is that the best approach to this? If so, how can this be implemented, especially since there is no DateDiff function in Power Query/M? If not, what is a better approach?