Forum Discussion

yodha's avatar
yodha
Helper IV
6 years ago
Solved

How to create Date column using M language

Hi, I have a Data Source that contains YEAR, MONTH columns but there is no DAY column. I wanted to create a DATE column using Query Editor/M language: 1. Add new column 2.Populate it with D...
Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi yodha 

     

    Please see the below.

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi everyone,

I do have the same problem but face further issues here.

Following your instructions, my output still shows an "Error".

 

= Table.AddColumn(AddCol_Day, "Date", each #date( [Year], [Month],1))

 

Columns Year and Month are formatted as Int64.Type.

Any hints?