Forum Discussion

stefans124's avatar
stefans124
New Member
4 years ago
Solved

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...
  • tamerj1's avatar
    tamerj1
    4 years ago

    stefans124 

    Date =
ADDCOLUMNS (
    CALENDARAUTO (),
    "Year", YEAR ( [Date] ),
    "Month", FORMAT ( [Date], "mmmm" ),
    "Month Number", MONTH ( [Date] ),
    " Year Month Number",
        YEAR ( [Date] ) * 100
            + MONTH ( [Date] )
)
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

stefans124 

Date =
ADDCOLUMNS (
    CALENDARAUTO (),
    "Year", YEAR ( [Date] ),
    "Month", FORMAT ( [Date], "mmmm" ),
    "Month Number", MONTH ( [Date] ),
    " Year Month Number",
        YEAR ( [Date] ) * 100
            + MONTH ( [Date] )
)
stefans124's avatar
stefans124
New Member
4 years ago

Hey, thank you very much Tamer, really saved my day! Kudos to You!