Forum Discussion

mlmchilli's avatar
mlmchilli
Frequent Visitor
3 years ago
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...
Need Help
v-yadongf-msft's avatar
v-yadongf-msft
Community Support
3 years ago

Hi mlmchilli ,

 

I cannot understand  "lose all of the days in the month for Product 1", can you provide more details?

 

Best regards,

Yadong Fang

mlmchilli's avatar
mlmchilli
Frequent Visitor
3 years ago

In the screenshot of your results you only have the last 7 days of data for product 1 so Jan 1,2,3 are missing. We would need to see all days data where the total sales amount in the last 7 days is over £1000. Perhaps this is because you are filtering the fact table down to the last 7 days in your first statement?