Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Analytics4Life1
Regular Visitor

How to combine month and year columns into MM-YYYY

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!

1 ACCEPTED SOLUTION
v-deddai1-msft
Community Support
Community Support

Hi @Analytics4Life1 ,

 

Would you please try the following calculated column:

 

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

 

Capture3.PNG

 

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

View solution in original post

5 REPLIES 5
Syndicate_Admin
Administrator
Administrator

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
Community Support
Community Support

Hi @Analytics4Life1 ,

 

Would you please try the following calculated column:

 

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

 

Capture3.PNG

 

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

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

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
Super User
Super User

@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")

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.