Forum Discussion
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','')
2 Replies
- amitchandakSuper User
Anonymous , Can you explain what are you try to do here.
Also refer: https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/
- camargos88Community Champion
Anonymous ,
Some data as example would help with the question.