Forum Discussion

sbowles's avatar
sbowles
Regular Visitor
10 years ago

How do i create a date table ?

I was trying to create  a date table for filtering.. And ran across this DAX (below) ... thinking it looked useful.  However when I went to create the table and use it.. Didn't seem to work..    e...
PeterBI's avatar
PeterBI
Helper I
10 years ago

Hi Giles,

 

Thanks for your Suggestion. I get with the first step the first error - Wrong Syntax.

I am using the actual PowerBI Desktop Version. Thanks for a Hint ;-)

 

Kind Regards, Peter

 

 

 

sdjensen's avatar
sdjensen
Solution Sage
10 years ago

Depending on your regional settings you will need to replace the , with ;

 

So try this instead: DateKey = CALENDAR(DATE(2012;01;01); DATE(2017;06;30))

 

if that works you should do the same with all the other steps.

  • PeterBI's avatar
    PeterBI
    Helper I
    10 years ago

    Hi sdjensen,

     

    this was the solution. Every comma has to be a semicolon in Germany. We have a decimal comma.

    PowerBI changes some commas automatic and some not. You have to look very carefully, because some formulas work and some need manual work.

    Thanks, Peter