SanderBI's avatar
SanderBI
Frequent Visitor
7 years ago
Status:
Needs Info

Date Function (DAX)

When creation a calender table with DAX I run into an error that can only be solved with using double delimiters:

 

Below you see that on the second line I entered ",," as a dilimeter.  If i don't I'll get this error message:

"Too few arguments were passed to the DATE function. The minimum argument count for the function is 3."

 

Calendar = ADDCOLUMNS (
CALENDAR (DATE(2018,,1,,1), DATE(2025,,12,,31)),
"DateAsInteger", FORMAT ( [Date], "YYYYMMDD" ),
"Year", YEAR ( [Date] ),
"Monthnumber", FORMAT ( [Date], "MM" ),
"YearMonthnumber", FORMAT ( [Date], "YYYY/MM" ),
"YearMonthShort", FORMAT ( [Date], "YYYY/mmm" ),
"MonthNameShort", FORMAT ( [Date], "mmm" ),
"MonthNameLong", FORMAT ( [Date], "mmmm" ),
"DayOfWeekNumber", WEEKDAY ( [Date] ),
"DayOfWeek", FORMAT ( [Date], "dddd" ),
"DayOfWeekShort", FORMAT ( [Date], "ddd" ),
"Quarter", "Q" & FORMAT ( [Date], "Q" ),
"YearQuarter", FORMAT ( [Date], "YYYY" ) & "/Q" & FORMAT ( [Date], "Q" )
)

Does anyone have an idea?

5 Comments

  • Anonymous's avatar
    Anonymous
    Not applicable

    SanderBI ,

    I am not able to reproduce this issue on my side. What is your Power BI Desktop version?



    Regards,
    Lydia

  • SanderBI's avatar
    SanderBI
    Frequent Visitor

    Anonymous  I understand. See below.Showing the errorwith double comma's

  • Anonymous's avatar
    Anonymous
    Not applicable

    SanderBI ,

    Do you also get the issue if you install Power BI Desktop in other machines? And do you get same issue when installing previous version of Power BI Desktop in current machine?

    Regards,
    Lydia

  • SanderBI's avatar
    SanderBI
    Frequent Visitor

    A colleague if mine just got the same issue on another machine. I did not have it in previsous versions.