cancel
Showing results for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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)

1 ACCEPTED SOLUTION
Super User
``````Date =
CALENDARAUTO (),
"Year", YEAR ( [Date] ),
"Month", FORMAT ( [Date], "mmmm" ),
"Month Number", MONTH ( [Date] ),
" Year Month Number",
YEAR ( [Date] ) * 100
+ MONTH ( [Date] )
)``````
4 REPLIES 4
Super User
``````Date =
CALENDARAUTO (),
"Year", YEAR ( [Date] ),
"Month", FORMAT ( [Date], "mmmm" ),
"Month Number", MONTH ( [Date] ),
" Year Month Number",
YEAR ( [Date] ) * 100
+ MONTH ( [Date] )
)``````
New Member

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

Super User

Hi @stefans124
" Year Month Number", YEAR ( [Date] ) * 100 + MONTH ( [Date] )

New Member

Date =

CALENDARAUTO(),

"Year", YEAR([Date]),

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

"Month Number", MONTH([Date])

)

(this is the code written)

Announcements

#### Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

#### Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

#### The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors