Create Date column Power Query - Power BI

[Anonymous]

Hi Experts

I want to create a new column in Power Query to represent date. Column C_Year give Year as Number and Column C_Month give Month Jan as a text - How could i create new column to give me 01/01/2020 or 01/Jan/2021 based on the above two column. 

[negi007 · Accepted solution]

@Anonymous 

It is simple, in your power query window you select both year and month columns and right click to select option add column from example. Then in the below window, you type the value in the format you want. Power query will automatically pick or create new column values basis your input.

Once you have data in column, you can then change the format to date type. Let me know if it works for you.

[Anonymous]

Hi negioo7 

Excellent thanks for the easy tip