How to combine month and year columns into MM-YYYY

[Analytics4Life1]

Hello,

I am still very new to Power BI and was playing around with some sample data today.

I have a Year column in YYYY format, and Date Number column (1= January, 12 = December). 

Could someone help me with the formula I would use to combine these two columns to get a MM-YYYY date column?

Thanks!

[Syndicate_Admin]

Hello, and if additional to that I would like to add a day even if this table does not exist. How could I do it?

[v-deddai1-msft · Accepted solution]

Hi @Analytics4Life1 ,

Would you please try the following calculated column:

Date = FORMAT(DATE('Table'[YERR],'Table'[Month],1),"MM-YYYY") 

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

[mutlus]

What if the Month column is not numbers but names of the months??

[Hari730]

Thanks for the above information.

But how can I combine Date, Month, Year at the same time?

I am getting error while doing.

Please help!

[amitchandak]

@Analytics4Life1 , You need year and month for this . Assume both are in number format

format(Date([year],[month],1),"MM-YYYY") //where year and month are columns

format([Date],"MM-YYYY") //Date is a column

format(today(),"MM-YYYY")