Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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','')
@Anonymous , Can you explain what are you try to do here.
Also refer: https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
42 | |
33 | |
30 | |
18 | |
18 |