Change the format of a calculated column when using FIRSTONBLANK column

[helen_p]

 Dear Power BI user

I was wondering if someone could kindly help me

I have a column in table 1 which is called "StartDate" and this is a text field

I am using the FIRSTONBLANK function to bring the "StartDate" field into table 2 but wish the calculated column to be in Date/Time format....I get an error if I just change the data type

The DAX expression I am using in table 2 is: 

FIRSTNONBLANK('table1'[StartDate])

Any help is greatly appreciated

Kind Regards

Helen

[Vera_33]

Hi @helen_p 

Can you provide some sample data of your Table1[StartDate]? I tried to use Text in Table1, and it worked