Calculate active client who bought item in last month

[annika29]

Hi

How can i calculate active clients who made a purchase at least once a month based on the data?

https://gofile.io/?c=PvQqNl

I looked at previous, similar threads, but they seem to have different data

[v-xuding-msft]

Hi @annika29 ,

Can you please post the expected results? For your sample data, I can not understand the relationships among them clearly.

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

OP here, had problems with that account 

IT would look something like this after user checks year with filter:  https://ibb.co/0DzjH2T

Can this also be done, if it show's clients who didnt buy/use any products in year and clients who bought/used more than one?

So like 3 number graphs.

@v-xuding-msft 

[Anonymous]

Any ideas? Or is it better to make some kind of new table? Customer by revenue by product?