Forum Discussion
Create Date column Power Query - Power BI
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
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.
Hi negioo7
Excellent thanks for the easy tip