How can I get Count of row in number in New Column with Filter by dates

[PeraZo]

Hello community,

I have a dataset like below.

I want to Count number of Product (not unique but just count) filtering just for 7 days in each column and show it on the new column.

For example, AAA on Date 2024/1/11 would be 7 because there is one Product for every single day but 2 for Date 2024/1/2 because there is only 2 days within previous 7 days.

Could you please help me out?

I tried to use calculate count but it showed up error for circular problem.

Please help, and thank you in advance.

[PeraZo]

Hello Ryan_mayu

Thank you so much.

This is exactly what I wanted!!!

Thank you

[ryan_mayu]

you are welcome

[ryan_mayu · Accepted solution]

@PeraZo 

is this what you want?

Column = countx(FILTER('Table','Table'[product]=EARLIER('Table'[product])&&'Table'[date]<=EARLIER('Table'[date])&&'Table'[date]>EARLIER('Table'[date])-7),'Table'[product])