Help! Date column is in type text and cannot be converted to date

[jstacruz]

Hello all!

I need your help to see why this specific error occurred. Here is a photo of my dataset:

I created "Month Closed" and "Year Closed" table based from the date/time column "Last Update Time" to get the closed date. For some odd reason, when I'm trying to combine both month and year using the query on the photo, it produces an error that cannot convert "" of type Text to type Date. I find it peculiar because I tried it to combine columns "Month Created" and "Year Created" for => "Month Year Created" column and it worked perfectly. I checked the data type of "Last Update Time" but it's in right format.

Do you have any idea on why this is happening?

Thanks so much.

Regards,

Nina

[Ashish_Mathur · Accepted solution]

Hi,

There is a blank cell in one of the two column.  See if this works

=IFERROR(your_formula,BLANK())

[jstacruz]

There are no blank cells for the columns. And I tried the query, it did not change anything 

[Nishantjain]

In your screenshot, I can see the data type as date. Have you tried to change it to text?

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.  I will try to correct for the mistake in your formula.