Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Calendar creation - DAX vs table

Hello.
I've just joined an organization where Calendars are created using Dax and deployed in each report.
I'm more confortable with building a calendar table instead, and would prefer to build it in a centralized location (like Fabric) and link to the calendar.  But for now I will be creating Calendars in each report.

But I'm wondering whether it's better to create a table or continue with the Calendar deployment using DAX.  The reports are in import mode only.

Is it better for resources, maintenance, efficiency, etc., to create a table or a dax calendar?


Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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?

  • Anonymous's avatar
    Anonymous
    1 year ago

    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

3 Replies

  • ajohnso2's avatar
    ajohnso2
    Icon for Solution Supplier rankSolution Supplier
    1 year ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      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?

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        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