cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
zorobin33 Frequent Visitor
Frequent Visitor

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

Accepted Solutions
Super User
Super User

Re: COMBINEVALUES function not shown in drop down menu

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]

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


ChrisMendoza Senior Member
Senior Member

Re: COMBINEVALUES function not shown in drop down menu

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]

 

 

4 REPLIES 4
Super User
Super User

Re: COMBINEVALUES function not shown in drop down menu

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]

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


ChrisMendoza Senior Member
Senior Member

Re: COMBINEVALUES function not shown in drop down menu

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]

 

 

zorobin33 Frequent Visitor
Frequent Visitor

Re: COMBINEVALUES function not shown in drop down menu

Yes this worked perfectly! Thank you Smiley Happy

zorobin33 Frequent Visitor
Frequent Visitor

Re: COMBINEVALUES function not shown in drop down menu

Hi Dozer, 

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

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 263 members 2,898 guests
Please welcome our newest community members: