Only 90 Days of Data in Azure Analysis Services

  • imani_technology

    SSCrazy Eights

    Points: 8186

    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?

  • Site Owners

    SSC Guru

    Points: 80372

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply