Sample Header Ad - 728x90

Dax Formula for Calendar

1 vote
1 answer
167 views
I have been trying to make a new table and want to use the date of the existing data. Can anyone help me understanding what is wrong with this formula?
dDate = CALENDAR(DATE(YEAR(MIN(Ftransactions[Date])),1,1),DATE(YEAR(MAX(Ftransactions[Date])),12,31))
The error which keeps popping up after pressing enter is: > An argument of function 'YEAR' has the wrong data type or the result is too large or too small. If the argument is expected to be a date, that date must be between January 1, 100 and December 31, 9999.
Asked by alphabounce_1228 (11 rep)
Apr 16, 2020, 11:08 AM
Last activity: Jul 4, 2025, 09:08 PM