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

lbendlin , gmsamborn ,

I think I understand the problem better,
Excel and Power BI don't work the same way for creating tables.

Indeed lbendlin , you are right, we must to do this from scratch in Excel.

 

I used the code from lbendlin in Power BI and it works very well (see 

Table1)


The one in the link, which is more complex, gives the same result (see Table2)
I'll see how I can create a new table in Excel

Best regards