DATESQTD Quarter-To-Date

paulkltam

New Member
Joined
Apr 11, 2014
Messages
14
If the company's fiscal year ended as at 30 Nov, any Dax to work out the quarter-to-date amount? 1st Quarter will be Dec-Jan-Feb, 2nd Quarter will be Mar-Apr-May, 3rd Quarter ..... The problem is DATESQTY is just designed for calendar quarters. Can it be adjusted from calendar qarters to fiscal quarters?
 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

GDRIII

Board Regular
Joined
May 30, 2014
Messages
88
DATESYTD() allows you to change your Year End Date but, DATESMTD() and DATESQTD() do not.

That said you re going to have to create some FIRSTDATE() and LASTDATE() Measures and or use DATESBETWEEN() to get what you want after you make yourself a custom periods table and link it up with your calendar...
 

Watch MrExcel Video

Forum statistics

Threads
1,108,711
Messages
5,524,436
Members
409,577
Latest member
Dwg

This Week's Hot Topics

Top