The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
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.