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.

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

Hello lbendlin ,

Thank you for your message,
Unfortunately, it didn't work for this example,
I don't know whether the DAX formula instruction in the link is intended to create a new table of dates or to add a new column to the existing table.
I can't get the DAX formulas to work.
Maybe I'm doing it wrong!

Thanks in advance

Best Regards

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

Hi Mederic  lbendlin 

 

I don't know anything about Power Query in Excel but it appears that you are trying to create a table in the window meant for creating a measure.

 

I wish I could help more but I'm unsure of how to create a table.