Only 90 Days of Data in Azure Analysis Services

• imani_technology

  SSCrazy Eights

  Points: 8200

  More actions

  October 15, 2020 at 2:36 pm

  #3797644

  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: 80320

  More actions

  October 16, 2020 at 3:10 pm

  #3798065

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

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