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.
Omega
Impactful Individual
Impactful IndividualIt 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.