- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Dozer,
Yes that was what I intended to do. Thanks for your help!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Yes this worked perfectly! Thank you 🙂

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
09-14-2021 02:19 AM | |||
12-19-2024 11:12 PM | |||
Anonymous
| 09-27-2018 12:04 AM | ||
06-22-2024 06:17 PM | |||
07-27-2022 07:31 AM |
User | Count |
---|---|
141 | |
115 | |
84 | |
63 | |
47 |