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
- AnonymousNot applicable
SanderBI ,
I am not able to reproduce this issue on my side. What is your Power BI Desktop version?
Regards,
Lydia - AnonymousNot applicable
- SanderBIFrequent Visitor
Anonymous I understand. See below.Showing the errorwith double comma's
- AnonymousNot 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 - SanderBIFrequent Visitor
A colleague if mine just got the same issue on another machine. I did not have it in previsous versions.