Power BI
NewAdd optional margin of years (before oldest and after earliest date) to the date table used by Auto Time Intelligence
Josdeyvi Magalhes Russi on 06 Oct 2022 18:09:34
Today some time intelligence functions, like DATEADD, use a calculate date/time table, when the auto date/time is enabled, based on the dates you have in the data table you are working with.
But, for example, if the DATEADD returns a date older then the oldest date in the date/time table, or in the future, the result will be blank.
If you had in the auto date/time option a way to add a margin of years, before and after the dates you have, you could enable the use of those time intelligence functions even if the calculated date was in the future or before than the oldest date you have in the work table.