Azure Analysis Services Rolling Weekly Partitions

Question

What is the best way to create rolling weekly partitions for Azure Analysis Services? We would like to be able to process the most recent week of data.

Answer 1

Hello @James H. Robinson ,
Thank for the ask and using the Microsoft Q&A forum .
We think you can use the steps called out here .Also I think we can use a query similar to one mentioned below .

SELECT [dbo].[Sales].* FROM [dbo].[Sales]  
WHERE (([OrderDateKey] >= WorkDate >= dateadd(day, 1-datepart(dw, getdate()), CONVERT(date,getdate())) )   
AND ([OrderDateKey] <= dateadd(day, 8-datepart(dw, getdate()), CONVERT(date,getdate()))  
))  

Thanks
Himanshu
Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members