How to create Date column using M language

[yodha]

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 Dates by using 1 as DAY for all the rows in the table.

End result Should be like : 2018/1/1 (Year/Month/Day)

Any help on this much appreciated, thanks in advance !

[JoseAndres]

Thanks

[Anonymous]

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?

[amitchandak]

@yodha , refer if this can help

https://radacad.com/create-a-date-dimension-in-power-bi-in-4-steps-step-1-calendar-columns

[Mariusz · Accepted solution]

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]

Thank you so much!