Forum Discussion
orana
Helper I
Helper IShow 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 ...
Ashish_Mathur
Super User
Super UserHi,
Create a Calendar Table with a relationship from the Date column of the Purchase date table to the Date column of the Calendar Table. In the Calendar Table, write calculated column formulas to extract Year, Month name and Month number. Sort the Month name column by the month number column. Via slicers, select Year and Month name. To your matrix visual, drag Customer Name and drag this measure
Measure 1 = min(Data[Purchase date])
Does this help?