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: | |

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 131 members 1,815 guests
Please welcome our newest community members: