Provide support for Custom Calendars AND default Time Intelligence Functions

[anthony_newell]

Currently, the native Time Intelligence functions work on the basis of having a regular calendar There are many instances of custom calendars like Retail 4-4-5 In order to get 'time intelligence' you can replicate the standard functions with more longwinded DAX I would like to see out-of-the-box support for custom calendars

[kevin_biely]

This is a great idea!

[awilbourn]

I believe the 4-5-4 is similar to a 4-4-5 accounting calendar. There are some common calendars for running business, so we to request that time calculations can be set to use standard periods such as 4-4-5 and not based on a calendar year.

[zoller]

This is a common problem, very surprised it doesn't have more votes.

[j_hoskinson]

Yes!!!! You can't use any of the quick measure time intelligence features with customer calendars, among other pain points. This would save me a few hours a week. Also, there are several custom calendar idea submissions on this board. It might be a good idea for the support team to consolidate them to get a better gauge of the interest in customer calendars.

[nishalit]

Support for Custom Calendar such as 4-5-4 so that data can be analyzed for Current and Prior Periods using DAX such as TOTALYTD etc.

[nishalit]

It would be great if there was a way to set a custom calendar. Currently all the calendar functions such as YTD, MTD, QTD, etc. function off of a standard calendar. But a large swath of industries work with different fiscal calendars, for example a Q2-Q2 calendar or in retail where fiscal calendars tend to start post February. It would be great if we could define a start / end date for the year and define period start/end dates for months, quarters, etc.

[nishalit]

It would be great if there was a way to set a custom calendar. Currently all the calendar functions such as YTD, MTD, QTD, etc. function off of a standard calendar. But a large swath of industries work with different fiscal calendars, for example a Q2-Q2 calendar or in retail where fiscal calendars tend to start post February. It would be great if we could define a start / end date for the year and define period start/end dates for months, quarters, etc.

[nishalit]

I'm using a custom retail calendar, but once published on powerbi.com the system get the date column as the reference. so when the user are using the Q&A feature and ask for this year sales, the wrong year is returned.