Forum Discussion

cronline's avatar
cronline
Regular Visitor
9 years ago
Solved

Error relating to the DATE Function when creating a Date table - Too Few Arguments Passed

Hi,   I am trying to create a Date Table and in creating a Date column, I have come across an unexpected error to do with the DATE Function. The DAX I am using, after clicking on the "Add Table" bu...
Need Help
  • cronline's avatar
    cronline
    9 years ago

    OK, I have got this working now and the solution is as Bizarre as the initial problem. Below is the DAX syntax that worked.

     

    DateTable = CALENDAR(DATE(2015 ,01 ,01),DATE(2016 , 01 , 01) )

     

    What's different? I hear you ask, well, before the comma delimiter between there is a space, so, "2015 ," instead of "2015,". Same for the Month.

     

    If anyone could explain this, I would love to know the reason this is happening.

     

    Thanks

    Chris

cronline's avatar
cronline
Regular Visitor
9 years ago

OK, I have got this working now and the solution is as Bizarre as the initial problem. Below is the DAX syntax that worked.

 

DateTable = CALENDAR(DATE(2015 ,01 ,01),DATE(2016 , 01 , 01) )

 

What's different? I hear you ask, well, before the comma delimiter between there is a space, so, "2015 ," instead of "2015,". Same for the Month.

 

If anyone could explain this, I would love to know the reason this is happening.

 

Thanks

Chris

Anonymous's avatar
Anonymous
Not applicable
9 years ago

I ran into the same issue.

An other way to work around this is by enclosing all values in ()

 

DATE((2016),(1),(1))

 

I think it has something to do with regional settings causing the comma to be interpreted as a decimal sign.

  • michellepace's avatar
    michellepace
    Resolver III
    6 years ago

    Goodness, two years later and I'm finding the same issue. 

     

    DateTable = CALENDAR(DATE(2015 ,01 ,01),DATE(2016 , 01 , 01) ) ... this works
    DateTable = CALENDAR(DATE(2015,01 ,01),DATE(2016 , 01 , 01) )  ... this gives me the above error