Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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]
Proud to be a Super User!
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]
Proud to be a Super User!
Hi Dozer,
Yes that was what I intended to do. Thanks for your help!
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]
Yes this worked perfectly! Thank you 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |