Date Function (DAX)

[SanderBI]

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?

[v-yuezhe-msft]

@SanderBI ,

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



Regards,
Lydia

[SanderBI]

@v-yuezhe-msft  I understand. See below.Showing the errorwith double comma's

[v-yuezhe-msft]

@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]

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