Forum Discussion
Calendar creation - DAX vs table
Thanks for responding. I don't know when they'll be a switch over to a centralized calendar, but in the meantime, is it better to have a calendar table or one created with DAX?
Hi Anonymous ,
At this stage then I think it should be more efficient to use DAX. You can just save your DAX code and when you need to create a calendar table, copy the appropriate DAX code. You can also flexibly modify the structure of the calendar table according to your needs.
Best Regards
I think you have answered your own question really.
Having 1 single point of failure here would be the best bet, in my company i've created the calendar as a dataflow (from our warehouse) and have a pbi template where all the columns used are categorized, placed in folders, renames etc. This eliminates having to 'redo' everything in all new reports.
Thanks for responding. I don't know when they'll be a switch over to a centralized calendar, but in the meantime, is it better to have a calendar table or one created with DAX?
Hi Anonymous ,
At this stage then I think it should be more efficient to use DAX. You can just save your DAX code and when you need to create a calendar table, copy the appropriate DAX code. You can also flexibly modify the structure of the calendar table according to your needs.
Best Regards