Convert String to Date using Power Query editor

[ShubhamBarnwal]

I am trying to add a column using below formula in power query editor:

Variance = Int32.From(Date.From([BaselineFinishDate])-Date.From([ActualFinishDate]))

Below is the output:

Earlier it was working fine. But now somethings's wrong. Need help to fix it. 

[Anonymous · Accepted solution]

Hi @ShubhamBarnwal,

What’s the data type of column BaselineFinishDate and ActualFinishDate? Date or Text type?

The "variance" column worked normally before as you wrote in the case, but something went wrong now. It may be due to a date format problem. Please try to update the proper date format for this 2 columns by the following steps:

1. Select the related column, right click (Change Type --> Using Locale...)

2. Update with the proper format

  

You can check this documentation for the full details.

Best Regards

Rena

[amitchandak]

By using Date.From, first create a new column and check dates are coming correct.

Also if you can use dax. Then, if these are detected as date you can use datediff.