Power Query Formula to give dates based on another column

Hi Anonymous ,

Based on your description, you can create a custom column in Power Query.

Date=Date.AddDays(#date(2012,1,1),Number.FromText(Text.End([M],Text.Length([M])-1)))

Then transform the text type of the column into date type.

Finally you can change the type to "mm/dd/yyyy" in data view or report view.

Result:

Hope that's what you were looking for.

Best Regards,

Yuna

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.