Forum Discussion
Help creating date table that includes fiscal hierarchy
Hello I used PBi occasionaly over the last year and just finished a 4 week weekend training and now trying to build more robust reporting and dashbaords and one of my goals is to create a Date Table ...
That is truly, uhm, impressive.
Throw it away and instead maintain your fiscal calendar table in an outside tool like SQL Server or - worst case - an Excel file. Then load that data source into Power BI and mark it as a Dates table. Don't forget to disable the Auto Date/Time hierarchies.
Hmm I am not familair wuth using SQL Server and my the whole point of this was to avoid worst case scenario of having to maintain a manual table that has to be updated 😕
I know it is hard for people to learn from someone else's mistakes, but trust me on that. Having to maintain a manual table is NOT the worst case scenario in your situation.