Forum Discussion
Helper IIHow to USE a date table
Helper IIInteresting, so basically creating an alias table in DAX.
Not sure why you say that it is complex for end users to understand multiple date tables. From my perspective, this is way easier for an end user to utilize rather than loading the model with measures for every date and every "by" dimension utilizing USERELATIONSHIP.
I was hoping that once you defined a date table in the model, then PowerBI would automatically create a 'hierarchy' for every date in your fact table, using the objects from your declared date table. Then, no matter which of the 14 dates the user wants to use in PowerBI Service to build a report, they have every dimension off of the date table to use.
My hopes of PowerBI being this smart has dwindled. Still my perspective of declaring a "Date" table seems useless.
Resident RockstarHi therealomacoder,
you can do 2 different things. Either you create your own date dim table / tables or you can create a date hierarchy on every date/datetime column in your model ==> PowerBI is smart at this point in the way you expect ;)
(But be careful how big your pbix file becomes when having many date dimensions.)