cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
stefans124
New Member

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)

stefans124_0-1655279444321.png

 

1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

@stefans124 

Date =
ADDCOLUMNS (
    CALENDARAUTO (),
    "Year", YEAR ( [Date] ),
    "Month", FORMAT ( [Date], "mmmm" ),
    "Month Number", MONTH ( [Date] ),
    " Year Month Number",
        YEAR ( [Date] ) * 100
            + MONTH ( [Date] )
)

View solution in original post

4 REPLIES 4
tamerj1
Super User
Super User

@stefans124 

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!

 

tamerj1
Super User
Super User

Hi @stefans124 
Just add anew line inside ADDCOLUMNS
" Year Month Number", YEAR ( [Date] ) * 100 + MONTH ( [Date] )

stefans124
New Member

Date =

ADDCOLUMNS (

 CALENDARAUTO(),

 "Year", YEAR([Date]),

 "Month", FORMAT([Date], "mmmm"),

 

 "Month Number", MONTH([Date])

 

)

 

 

(this is the code written)

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power BI Dev Camp Session 27

Ted's Dev Camp

This session walks through creating a new Azure AD B2C tenant and configuring it with user flows and custom policies.