Forum Discussion
Create Date column Power Query - Power BI
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.
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.
2 Replies
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.