Forum Discussion
Solved
"An unexpected error occurred (file '', line , function '')" error
Hello, I'm unable to use DATE(year,month,day) function because I'm getting this error An unexpected error occurred (file '', line , function '') please advise Thanks, Karoon
Hi kgayzagian ,
make sure that you choose the columns of your table, Date('Table'[year], 'Table'[month], 'Table'[Day]) not the year() function, and also make sure that they are in date format and you dont have any null values in these columns. If this doen't help please upload your exact formula and error (screenshots).
If this post helps, then I would appreciate a thumbs up 👍 and mark it as the solution ✔️ to help the other members find it more quickly.
thank you all. appreciate your help