SQL to DAX

[Anonymous]

Hi

Could someone please help me to convert this in to DAX.

IIF(stop_action_description = 'Pick Up', (
   IIF((
     NOT ISNULL(aa_event_date_et)
     AND TO_CHAR(aa_event_date_et, 'YYYY-MM-DD') <> '1900-01-01'
     AND TO_CHAR(aa_event_date_et, 'YYYY-MM-DD') <> '2000-01-01'
     ), aa_event_date_et, IIF(TO_CHAR(schdarrivetodt_et, 'YYYY-MM-DD') <> '2000-01-01' AND NOT ISNULL(schdarrivetodt_et)
     , schdarrivetodt_et, TO_DATE('1900-01-01 00:00:00', 'YYYY-MM-DD HH24:MI: SS')))
   ), IIF((
    stop_action_description = 'Delivery'
    OR stop_action_description = 'Pick Up - Delivery'
    ), IIF((
     NOT ISNULL(last_agreed_dt_et)
     AND TO_CHAR(last_agreed_dt_et, 'YYYY-MM-DD') <> '1900-01-01'
     ), last_agreed_dt_et, IIF((
      NOT ISNULL(ab_event_date_et)
      AND TO_CHAR(ab_event_date_et, 'YYYY-MM-DD') <> '2000-01-01'
      ), ab_event_date_et, IIF((TO_CHAR(schddeparttodt_et, 'YYYY-MM-DD') <> '2000-01-01')
      AND NOT ISNULL(schddeparttodt_et)
      , schddeparttodt_et, TO_DATE('1900-01-01 00:00:00', 'YYYY-MM-DD HH24:MI: SS'))))))

Thanks in advance

[v-danhe-msft]

Hi @Anonymous ,

Sorry, I am not farmiliar with Sql statements, could you please just post your sample data and explain your logic of your data and post your desired result if possible?

Regards,

Daniel He