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
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi orana ,

 

You could create a measure as below.

Measure = 
var first_date = CALCULATE(MIN('Table'[date]),ALLEXCEPT('Table','Table'[customer]))
return
IF(SELECTEDVALUE('Table'[date])=first_date,SELECTEDVALUE('Table'[purchase]),BLANK())

 

Best Regards,

Jay

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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi orana ,

     

    Using the above formula will get two records of 9/1/2021 for "a". What is the expected result?

     

    Best Regards,

    Jay

  • 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