Forum Discussion

orana's avatar
orana
Icon for Helper I rankHelper I
5 years ago

Show only initial customer purchase

Hello,   I currently have a bar chart that shows the number of customers who made purchases over a year. The y-axis shows the months and the x-axis shows a count of customer. A customer could have ...
Need Help
orana's avatar
orana
Icon for Helper I rankHelper I
4 years ago

Looking at my data, the dates seem to all be the first of each month so for the example provided - "a" would have the date 9/1/21, 9/1/21, 10/1/21. Is there a way to get around this?

orana's avatar
orana
Icon for Helper I rankHelper I
4 years ago

Hey,

 

It doesn't seem to be working. To help, I created a power bi example and shared the accompany excel file in the hopes that this will help. If you look at Sheet 2, you'll see that in Sept and November the customer "my" appears in both months. Ideally, i would only want "my" to show up when "my" made the its first purchase. This would be in Sept. 

 

Power BI example Accompanying Excel file 


Best,

Oscar