Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.