Calculated Column formula

[Learn_PBI]

Can some one help me in writing a calculated column formula to find the second min order date with respect to each user??

Thanks

[Greg_Deckler · Accepted solution]

@Learn_PBI Sample data would greatly help but it should be something along the lines of:

Column =
  VAR __Customer = [Customer]
  VAR __MinOrderDate = MINX(FILTER(ALL('Table'),[Customer] = __Customer),[OrderDate])
  VAR __SecMinOrderDate = MINX(FILTER(ALL('Table'),[Customer = __Customer && [OrderDate] <> __MinOrderDate),[OrderDate])
RETURN
  __SecMinOrderDate

[Learn_PBI]

@Greg_Deckler  Thanks man, appreciate your help and admire your skills.

[Learn_PBI]

@amitchandak @Greg_Deckler