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.
Can someone help me to get the DAX equivalent for the below :
select count(distinct DW_ACCT_ID) #ACCT,
MKT_REGION_CALC,
[MKT_PROD_LVL_2_NM],
[MKT_PROD_LVL_2_NM],
[COUNTRY],
[FISC_QTR_RLTV],
[FISC_WEEK_RLTV],
sum([REVN_AS_SLD_DISC_USD]) REV
from
[dbo].[vw_Dell_Order_Details]
where MKT_REGION_CALC = 'India' and [FISC_QTR_RLTV] = '-1'
Group by
MKT_REGION_CALC,
[MKT_PROD_LVL_2_NM],
[MKT_PROD_LVL_2_NM],
[COUNTRY],
[FISC_QTR_RLTV],
[FISC_WEEK_RLTV]
having sum([REVN_AS_SLD_DISC_USD]) > 1000000
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.