Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I'm a little stuck on this one.
I need to show the Monthly Customer Deposit Flow. as so:
as in, if in June we got 509 New customers (made their first deposit) I want to see what happened to those customers through out the months. like, then out of thos 509 only 121 made a repeat deposit in July the out of thos 509 made 20 in Aug ext
but always looking at the total new customers made in that month (509)
my data model has a Dim Date Connected to the Fact Tranastion table:
the Fact Table is structured as so:
maybe the probelms is DAX? or the data stucture?
i dont know
thank you
Solved! Go to Solution.
@Anonymous , Create a date of first deposit and then you can do them
New Column
First date = minx(filter(Table, [Customer] = earlier([Customer]) ), [Date])
refer this blog for rest
Customer Retention Part 3: Period Of Stay – Cohort Analysis: https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-3-Period-Of-Stay-Cohort-Analysis/ba-p/1393410
@Anonymous , Create a date of first deposit and then you can do them
New Column
First date = minx(filter(Table, [Customer] = earlier([Customer]) ), [Date])
refer this blog for rest
Customer Retention Part 3: Period Of Stay – Cohort Analysis: https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-3-Period-Of-Stay-Cohort-Analysis/ba-p/1393410
I did exactly what you said and it WORKED!!
thank you so much!
I wanted to know how I can take the empty slots and make a forcast" based on the %?
thanks
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |