Calculate first deposit date based on value in row date

[av9]

Hi,

I'm trying to calculate first deposit date for each of the 4 customers in the table below. As you can see my data provided each month is in the sample format below. Any help appreciated.

Customer	Date	Deposit
A	12/31/2018	200.00
B	12/31/2018	100.00
A	1/31/2019	200.00
B	2/28/2019	100.00
C	2/28/2019	50.00
A	3/31/2019	200.00
B	3/31/2019	100.00
C	3/31/2019	50.00
D	3/31/2019	25.00

[AlB · Accepted solution]

Hi @av9 

Try this, where Table1 is the table you show:

1. Place Table1[Customer] in the rows of a matrix visual

2. Create this measure and place it in values of the matrix visual

FirstDepositDate = MIN(Table1[Date])

[av9]

Thanks that worked. 

I used Edit Interactions to make sure page level slicers were ignored.