Forum Discussion

kgayzagian's avatar
kgayzagian
New Member
1 month ago
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
  • Selva-Salimi's avatar
    1 month ago

    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.