Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
Proud to be a Super User!
@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.
Proud to be a Super User!
Hi negioo7
Excellent thanks for the easy tip
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |