cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Avry_th
Frequent Visitor

An argument of function 'DATE' has the wrong data type or the result is too large or too small

Hello There, 

I have been searching for how to solve the DATE have wrong data type or the result is too large or too small, however couldn't get mine solved. 

 

My case is i only want the date that  have the current Year, current month and the Day of my Start date column. i have tried the below: 

 

NewDate = DATE(YEAR(TODAY()),MONTH(TODAY()),DAY('Commission Agent'[start_date]))
but it throw the error. 
Avry_th_0-1660720666255.png

 

i tried to the same with my Dim Date and it working fine. i am not sure what wrong with my start date column.

Could anyone help me with this please ?

Thanks 

1 ACCEPTED SOLUTION
ryan_mayu
Super User
Super User

@Avry_th 

are there any null values in the date column? 

 

If the date is null, day() can't return the whole number and you can build the new date column 

 

1.PNG

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

3 REPLIES 3
Avry_th
Frequent Visitor

@ryan_mayu , ah, yes my start date column had null values. thanks for helps 🙂

you are welcome





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




ryan_mayu
Super User
Super User

@Avry_th 

are there any null values in the date column? 

 

If the date is null, day() can't return the whole number and you can build the new date column 

 

1.PNG

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show Episode 10 Recap

The Power BI Community Show

Watch the playback when Amit Chandak, a Power BI Super User, demos how to use Field Parameters to make reports more dynamic.

Power BI Dev Camp Session 26

New Date - Check it Out!

Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!

Health and Life Sciences Power BI User Group

Health and Life Sciences Power BI User Group

Power BI specialists at Microsoft have created a community user group where customers in the provider, payor, pharma, health solutions, and life science industries can collaborate.

Top Solution Authors