Forum Discussion
Solved
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", dim...
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]
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]
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]
Hi Dozer,
Yes that was what I intended to do. Thanks for your help!
