SQL to DAX Conversion

Anonymous — Mon, 09 Nov 2020 11:30:51 GMT

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

Re: SQL to DAX Conversion

amitchandak — Mon, 09 Nov 2020 12:35:51 GMT

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

camargos88 — Mon, 09 Nov 2020 13:53:03 GMT

Anonymous ,

Some data as example would help with the question.