Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

SQL to DAX Conversion

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','')