Add a date column as the first of the month in Power Query

[Anonymous]

Hi Experts

I have the following columns a table and i want to add an additional column that gives the first day of the Month. 

Year (No.)          Month (text)      Add column (Date)

2020                  Jan                      01/01/2020

is this possible as a step in Power query.

[camargos88 · Accepted solution]

@Anonymous ,

You can use:

Date.FromText(Number.ToText([Year]) &"/"& [Month] & "/01")

If necessary, Date.FromText has a culture parameter...you can use it to be sure of the format.

https://docs.microsoft.com/en-us/powerquery-m/date-fromtext

[Anonymous]

Perfect thank you sir