Skip to main content

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 (8) 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