Forum Discussion
Helper IIHow to USE a date table
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.)
Helper III'm not understanding why this is so complex for me to comprehend!! Please stay with me here... :)
Trying to be more open minded.
I tried two things:
ONE:
1a. I imported a date table, and I defined that as "the one and only date table" that a model can have.
1b. This did nothing automatically. This added no hierarchies to all of my dates on the fact tables.
1c. I published the report to PowerBI Service. There were no automatic drill or filtering capabilities on Month/Quarter/Year (all attributes on the date table).
TWO:
2a. Manually defined a date table like you describe using DAX. I then flagged this as "the one and only date table" that a model can have.
2b. This did nothing automatically. This added no hierarchies to my dates from the fact tables.
2c. I published the report to PowerBI Service. There were no automatic drill or filtering capabilities on Month/Quarter/Year (all attributes on the date table).
Thus... I still persist declaring a table as "the one and only date table that a model can have" as practically useless? I am not understanding what features this enables by "declaring" that table as "THE DATE TABLE".
I hope you make sense of my confusion and can point me to a how-to video, etc for the purpose of declaring a date table. Thank you Nolock
Did you ever gain any insight on this front? I am in exactly the same position you were when you wrote this post and am hoping you have some resources to enlighten me about date tables in powerBI. Thanks for any help!