Forum Discussion

ALeef's avatar
ALeef
Resolver II
10 years ago

Possible Tip/Trick: Dynamic Date Dimension Table

I'm going to share the dynamic date dimension table I built, hopefully it is useful to someone!  I named it DateTable for this tutorial, and my fact table FactTable.   The table is built using the ...
Tips and Tricks
bernitorres's avatar
bernitorres
Regular Visitor
10 years ago

I am new to PowerBI and I don't understand how to actually create this table.

I tried creating a New Source -> Blank Query and inserting your query, but that doesn't seem to work.

 

Could you please add some more detailed steps on how to add it to the queries, for newbies like me? :)

  • konstantinos's avatar
    konstantinos
    Memorable Member
    10 years ago

    bernitorres You can create/import tables with 2 ways. One is importing with "Get Data" and the other is through DAX data modelling.

    You need to go to the data model view and in the ribbon go to modeling tab & select "New Table". thus using DAX language.

    The "Get data" uses M language which is used only for importing data to data model.

     

    Keep in mind that you need to already have import some data in order to see the :Modelling" tab..

    1.png

  • ALeef's avatar
    ALeef
    Resolver II
    10 years ago

    konstantinos has it right.  I made it using the New Table option on the ribbon.

    • ALeef's avatar
      ALeef
      Resolver II
      10 years ago

      I edited the table above to inclue ISO Week number, which also helped fix the Week Ending values.  Should be more accurate now.  Please let me know if you figure out how to break it!