SOLVED! Calculate the date of first aquisition

[Anonymous]

Solved with to following measure:

Measure = CALCULATE(MIN('dw_si FactSI'[Date]),VALUES('dw_si FactSI'[MemberCardNo]),ALL())

I have the following data, with transactions filtered by August (or any other year/month). I want to calculate the first date that a MembercardNo did a transaction, excluding the Date Slicer.

[v-easonf-msft]

Hi, @Anonymous 

Thanks for sharing, you can add your reply here and Accept as Solution to close this thread.

More people will learn new things here.

Best Regards,
Community Support Team _ Eason

[Anonymous · Accepted solution]

Solved with to following measure:

Measure = CALCULATE(MIN('dw_si FactSI'[Date]),VALUES('dw_si FactSI'[MemberCardNo]),ALL())