Skip to main content
Microsoft Idea

Power BI

Needs Votes

Provide support for Custom Calendars AND default Time Intelligence Functions

Vote (15) Share
Anthony Newell's profile image

Anthony Newell on 2016-06-06 03:38:15

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

Comments (9) Merged Idea (3)
Vote 6
jerome's profile image

jerome on 2015-09-12 00:15:41

Power BI

support for retail/marketing calendar or custom calendars

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.

Merged
Vote 7
saishyam ravindran's profile image

saishyam ravindran on 2017-03-17 11:21:27

Power BI

Custom Calendar 4-5-4 with ability to use it in DAX such as TotalYTD

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.

Merged
Vote 10
Selim's profile image

Selim on 2018-06-08 09:38:56

Power BI

global custom calendar

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 calenda...

Merged