Cannot convert value '' of type Text to type Integer

[Anonymous]

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.

[Omega · Accepted solution]

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]

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