Forum Discussion
Solved
M formulas to create date
Hi,
I have 3 column, one for year, one for month and one that is always 1.
I need to create a date using this 3 column and using M language .
How can I do?
Thanks
Hello Giada90 !
1. In Power Query Editor select the columns in this order: Day, Month, Year (Click on them while pressing the CTRL button).
2. In "Add Column" select "Merge Columns" and use the following options:
3. Change the new column Data Type to Date
2 Replies
Hello Giada90 !
1. In Power Query Editor select the columns in this order: Day, Month, Year (Click on them while pressing the CTRL button).
2. In "Add Column" select "Merge Columns" and use the following options:
3. Change the new column Data Type to Date
Thanks
