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.
I create 4th column to get date conversion as below:
trf_Due-Date_Calculee_Conv = DATE('Updated Alert-KPI Status'[trf_Due_Consolidee_year],
'Updated Alert-KPI Status'[trf_Due_Consolidee_month],
'Updated Alert-KPI Status'[trf_Due_Consolidee_day])
It gives me error "Cannot convert value '' of type Text to type Integer".
To my surprise, i aply the similar formulae in other reports and another field in the same file. It works fine.
But what mistake am i doing in deriving this column
Any help in this ?
I could see the data tyr to be text of Year, Month and day clumns i use in the date conversion column.
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.
2 Replies
Hi 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
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.
