Forum Discussion
Create a funnel
Hi i_stanescu_ro ,
You seem to be looking for patterns like this:
New and returning customers – DAX Patterns
You need to pick one of the implementations in advance based on actual needs:Hope helps.
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group
Not enough info in question to know what you need.
Hi there
Sorry if I wasn't very clear..
I need to somehow fill that table and that funnel with the data I already have (i enetered dummy data).
The issue is that I don't know how to calculate the first (initial) purchase date for each individual client per product..
Basically I need to know the products that were so appealing to my clients that they first bought.
This is for cross-selling purposes, example: you first eneterd my store cause you saw fresh apples in the display and bought them. The second time you bought my bread. So, let's say 80% of my new clients will come back for bread, so I need to advertise it targeting new clients, at their first purchase.
Hope this makes sense and thanks so much!
