Reply
zorobin33
New Member

COMBINEVALUES function not shown in drop down menu

Hi, 

I was trying to create a new calculated column called Period that joins the Month Number of Year and Calendar Year columns together by writing the following dax formula 

COMBINEVALUES("0", dimCalendar[CalendarYear], dimCalendar[MonthNumberOfYear])

However, I was not able to find the COMBINEVALUES function in the drop down menu and got errors for the above expression. 

Any idea why this particular function isn't available in powerpivot?

Thanks in advance. 

 

Regards, 

Angel 

2 ACCEPTED SOLUTIONS
Greg_Deckler
Super User
Super User

I believe that's a relatively new function so may not have made its way into your version of Excel. Can you just do:

 

Column = dimCalendar[CalendarYear] & "0" & dimCalendar[MonthNumberOfYear]


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

ChrisMendoza
Resident Rockstar
Resident Rockstar

hello @zorobin33,

 

COMBINEVALUES ( ) is a text function, So change your [CalendarYear] & [MonthNumberOfYear] to text.

 

I believe you're trying to achieve '201805' as a period id, correct?

 

If that is the case, you could do something like:

Column = Table4[Year]*100+Table4[Month]

 

 






Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Proud to be a Super User!



View solution in original post

4 REPLIES 4
ChrisMendoza
Resident Rockstar
Resident Rockstar

hello @zorobin33,

 

COMBINEVALUES ( ) is a text function, So change your [CalendarYear] & [MonthNumberOfYear] to text.

 

I believe you're trying to achieve '201805' as a period id, correct?

 

If that is the case, you could do something like:

Column = Table4[Year]*100+Table4[Month]

 

 






Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Proud to be a Super User!



Hi Dozer, 

Yes that was what I intended to do. Thanks for your help!

Greg_Deckler
Super User
Super User

I believe that's a relatively new function so may not have made its way into your version of Excel. Can you just do:

 

Column = dimCalendar[CalendarYear] & "0" & dimCalendar[MonthNumberOfYear]


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Yes this worked perfectly! Thank you 🙂

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)