Forum Discussion

Mederic's avatar
Mederic
Icon for Post Patron rankPost Patron
2 years ago
Solved

DAX calendar problem

Hello, I haven't used DAX for a while, I came across the link below which I would like to apply personally. However, I don't know this language at all and can't create the calendar despite the aut...
  • lbendlin's avatar
    lbendlin
    2 years ago

    What I haven't figured out yet is how to create a table in Excel that would then accept a DAX query.  I know you can bend the query of tables that are tied to existing connections, but I think you want to do this from scratch.

     

    gmsamborn good observation about the measure thing.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

You can simplify it like this:

 

 

= 
 ADDCOLUMNS (
 CALENDAR ( "2020-01-01" ;  "2022-12-31"  );
  "Calendar", FORMAT([Date]; "yyyyMM")
 )