Forum Discussion
Cannot convert value '' of type Text to type Integer
I was trying in DAX to get date field. CSV is my source wher i get the date field. By default in the query it considers it to be texts. I create 3 different columns to extract Year, Month and Date....
It might be because one of the rows contain blank value or non numberic value. In query editor, try filtering each column for a non numeric value.
affan
Solution Sage
Solution SageHi Anonymous
Can you share the date column data imported in Pbix. You can remove all other data and just keep the complete date column imported from CSV.
Regards
Affan