This topic contains 1 reply, has 2 voices, and was last updated by 
-
Posts
-
I’ve discovered something special about how Dax/Power Pivot handles date tables:
To get some time intelligence, I created a date table called Dates2017 and loaded into Data Model (Power Pivot). Initially it had just 1 column, called [Dates] with a range starting Jan 1, 2017 through Dec 31, 2017:
1/1/2017
1/2/2017
.
.
12/31/2017If I add a Calculated Column to Dates2017, calling it [Days30Prior] = DATEADD(Dates2017[Date],-30,DAY), the first 30 days show blank. The first date to evaluate [Days30Prior] is where [Dates] = 1/31/2017.
This is interesting behavior. It suggests that one of the ways in which a date table is different is in the range of allowed transformations.
Anyone care to elaborate or expand or correct me on this?
Greatly appreciated,
Dan BlissI’m fairly new to this, but from what I’d read that’s actually how I would have expected it to behave.
When you mark it as a Date Table, I think you’re kind of defining the range of valid dates.
The forum ‘Power Pivot’ is closed to new topics and replies.