Hi,
I am using below DAX query in SSIS. Now, i want to fetch only current quarter data .Could you please help me re-write my below query accordingly.
DAX Query:
"EVALUATE
(
FILTER(
Summarize('Metrics - Attributes',
'Metrics - Attributes'[Billed to ID],
'Metrics - Attributes'[End Cust1 Country],
'Metrics - Attributes'[End Cust1 Country Code],
'Metrics - Attributes'[Geo Code],
'Metrics - Attributes'[Revenue Distribution Type],
'Metrics - Attributes'[Sales Channel],
'Metrics - Attributes'[Revenue Organization],
'Metrics - Attributes'[Revenue Segment],
'Metrics - Attributes'[Market Segment],
'Metrics - Attributes'[Revenue Type],
'Metrics - Attributes'[Parent Customer],
'Metrics - Attributes'[Sold to ID],
'Metrics - Attributes'[MM] ,
'Metrics - Attributes'[Market Channel1],
'Metrics - Attributes'[Transaction Code],
'Metrics - Attributes'[Market Channel2],
' Calendar'[yyyyww],
' Calendar'[yyyyqq],
'Product'[Part Type],
'Product'[DSS SKUVertical],
'Product'[DSS PVCName],
'Product'[DSS SKU BRAND],
'Product'[AT vPro Tech],
'Product'[Market Code Name],
'Product'[Level 4],
'Product'[Profit Center],
'Product'[Die Code Name],
'Product'[Product Type],
'Product'[DSS Wayness],
\"[Net Amt]\", [Net Amt],
\"[Net Qty]\", [Net Qty],
\"[Gross Amt]\", [Gross Amt],
\"[Gross Qty]\", [Gross Qty],
\"[CDD Amt]\",[CDD Amt],
\"[CDD Qty]\",[CDD Qty],
\"[CGID Amt]\",[CGID Amt],
\"[CGID Qty]\",[CGID Qty],
\"[DPA Cr-Dr Amt]\",[DPA Cr-Dr Amt],
\"[Geo Min Price]\",[Geo Min Price],
\"[Average Selling Price (Net)]\",[Average Selling Price (Net)],
\"[Resale Price]\",[Resale Price],
\"[Salesout Resale]\",[Salesout Resale],
\"[Special Cost]\",[Special Cost],
\"[Std Disti Cost]\",[Std Disti Cost],
\"[Rebate Amt]\",[Rebate Amt]
)
)
)
Order by 'Metrics - Attributes'[Revenue Segment],
'Metrics - Attributes'[Market Segment],
'Metrics - Attributes'[Revenue Type],
'Metrics - Attributes'[Parent Customer],
'Metrics - Attributes'[MM],
'Calendar'[yyyyqq]"
