Forum Discussion
CONTATENATEX Formula
Hello, im having difficulties understanding the CONTATENATEX formula. I am a complete beginner in this code writing world but i need the formula to conjoin two columns into one for my studies project.
My task is to conjoin columns "Year" and "Month number" into a new column that would join those together showing a year and month together, respectively 202101, 202102 etc. Im just confused about where in the code should i put the formula and what to write in it. Any help will be appreciated! (Look at the picture below for the table and code)
Date = ADDCOLUMNS ( CALENDARAUTO (), "Year", YEAR ( [Date] ), "Month", FORMAT ( [Date], "mmmm" ), "Month Number", MONTH ( [Date] ), " Year Month Number", YEAR ( [Date] ) * 100 + MONTH ( [Date] ) )
4 Replies
- tamerj1
Community Champion
Date = ADDCOLUMNS ( CALENDARAUTO (), "Year", YEAR ( [Date] ), "Month", FORMAT ( [Date], "mmmm" ), "Month Number", MONTH ( [Date] ), " Year Month Number", YEAR ( [Date] ) * 100 + MONTH ( [Date] ) )Hey, thank you very much Tamer, really saved my day! Kudos to You!
Date =
ADDCOLUMNS (
CALENDARAUTO(),
"Year", YEAR([Date]),
"Month", FORMAT([Date], "mmmm"),
"Month Number", MONTH([Date])
)
(this is the code written)
- tamerj1
Hi stefans124
Just add anew line inside ADDCOLUMNS
" Year Month Number", YEAR ( [Date] ) * 100 + MONTH ( [Date] )
