cancel
Showing results for 
Search instead for 
Did you mean: 

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?

Status: Needs Info
Comments
Moderator

@SanderBI ,

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


Regards,
Lydia

Moderator
Status changed to: Needs Info
 
Visitor

@v-yuezhe-msft  I understand. See below.Capture 2.PNGShowing the errorCapture1.PNGwith double comma's

Moderator

@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

Visitor

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