Dax to get MIN date Created on

[adoalan]

HI all,

I need a bit of help in getting this SQL converted to Power BI DAX. Can you help please.

Thank you in advance

ado

[adoalan]

@Greg_Deckler  this is perfect. small changes but worked perfectly 

[Greg_Deckler · Accepted solution]

@adoalan Maybe:

Table =
  VAR __Min = MIN('nfp_giftaiddeclaration'[createdon])
  VAR __nfp_supporterid = MINX(FILTER('nfp_giftaiddelcaration',[createdon] = __Min),[nfp_supporterid])
RETURN 
  __nfp_supporterid