Help with Power BI

[Anonymous]

Hello,

I am trying to create a date column using a month column and year column. My formula  is:

=1*(Month_Dataset[[Period]&"01/"&Month_Dataset[year])

In the Custom Column box, I am getting the error that Token Comma Expected after "01/,":

=1*(Month_Dataset[[Period]&"01/,"&Month_Dataset[year])

When I add the comma, I still get the error. Any help is greatly appreciated.

Heather

[HashamNiaz · Accepted solution]

Hi @Anonymous !

You can use following DAX to create a date column;

NewDate = DATE(Month_Dataset[Year], Month_Dataset[Period], "01")

Regards,

Hasham

[v-deddai1-msft · Accepted solution]

Hi @Anonymous , 

You can use #date function :https://docs.microsoft.com/en-us/powerquery-m/sharpdate

=#date([your year column],[your month column],1)

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[HashamNiaz · Accepted solution]

Hi @Anonymous !

You can use following DAX to create a date column;

NewDate = DATE(Month_Dataset[Year], Month_Dataset[Period], "01")

Regards,

Hasham