cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
vasu_479 New Member
New Member

find current quarter in DAX query

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]"

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: find current quarter in DAX query

HI @vasu_479,

 

I'd like to suggest you use today function to extract current year and quarter as filter parameters.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
1 REPLY 1
Community Support Team
Community Support Team

Re: find current quarter in DAX query

HI @vasu_479,

 

I'd like to suggest you use today function to extract current year and quarter as filter parameters.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |