SQL to DAX Conversion

[Anonymous]

How to convert below SQL query to DAX-

select distinct fo.outlet_Id , o.[Outlet_Cd] as outletcode

from [SDDW].[FCT_USER_EV_DTLS] fo (nolock)

inner join

(select distinct F.outlet_Id , F.EV_dt

        from [SDDW].[FCT_USER_EV_DTLS] f (nolock)

        where f.ev_dt <='2020-10-31'

        and f.ctry_id = 6

        and f.ev_nm = 'app_remove'

        and f.busn_catg_cd='HPC'

    ) apprem on fo.outlet_Id = apprem.outlet_Id

      and fo.EV_dt > apprem.EV_dt

      inner join [SDDW].[DIM_OUTLET] o on fo.outlet_id = o.outlet_id

      where fo.ev_dt <='2020-10-31'

      and fo.busn_catg_cd='HPC'

      and fo.ctry_id = 6

      and fo.ev_nm not in ('app_remove','')

[camargos88]

@Anonymous ,

Some data as example would help with the question.

[amitchandak]

@Anonymous , Can you explain what are you try to do here.

Also refer: https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/