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

stevediaz's avatar
stevediaz
New Member
3 years ago

The error "Too few arguments were passed to the DATE function" occurs when you are not providing the required three arguments (year, month, day) for the DATE function in your DAX expression. Double-check your syntax and ensure that you are passing the arguments correctly. You can also consult the documentation or community forums for your specific development environment for further assistance.

 

Thank you .