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?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
DATESQTD Quarter-To-Date
- Thread starter paulkltam
- Start date
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...
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...
Upvote
0
