Forum Discussion
Solved
Filtering data based on last 7 days aggregate
Hello! I'm hoping somebody can help! I have data at a daily level in my fact. I would like to be able to filter months and show all days in that month where the sum of sales in the last 7 day...
Hi mlmchilli ,
Is this the result you want?
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello Yadong,
Apologies for the delay. I'm going to mark this as the accepted solution as it clearly works.
We are still trying to get this into our model as typically the model is a little more complicated than the simplistic example given here but we shall get it sorted.
Thanks for your help and guidance!