Find out how many users have purchased products

[ninu]

Hi all,

I am trying to find out how many users have purchased products and plot in a visual to give an idea about the sales within the date slicer selected by the end user of the report.

I have tried with calculated columns; however, it takes into account all the product purchases made by users instead of within the date range picked as I hoped it would.

My data (for 14th Feb as the date picked by the end-user) currently looks like this -

User ID	Product ID	Dates
user01	p1	14/02
user023	p2	14/02
user12	p3	14/02
user12	p4	14/02
user023	p3	14/02
user05	p1	14/02
user99	p2	14/02
user12	p3	14/02
user01	p2	14/02

The output I expect to see -  How many users have purchased the product how many times?

2 users have purchased 2 products

1 has purchased 3 products

2 have purchased 1 product

Users	Products
2	2
1	3
2	1

Please feel free to ask for more information. Thank you!

[lbendlin]

Unlike Tableau, Power BI does not support dynamic bucketing,  You need to bring your own buckets.

see attached