Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Customer Deposit Monthly Flow

Hello,

 

I'm a little stuck on this one.

I need to show the Monthly Customer Deposit Flow. as so:

Adambk_0-1637235072309.png

 

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:

Adambk_1-1637235336736.png

 

 

the Fact Table is structured as so:

Adambk_2-1637235408904.png

 

 

maybe the probelms is DAX? or the data stucture?

i dont know

thank you

 

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@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
Not applicable

I did exactly what you said and it WORKED!!

thank you so much!

Adambk_0-1637249484177.png

 

 

I wanted to know how I can take the empty slots and make a forcast" based on the %?

thanks

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.