Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ukeasyproj
Helper II
Helper II

error when extracting month from Date

temp1.PNG

 

I am trying to create a calculated column that extracts the month of a given date in the following format:

 

01

02

03

04

05

06

07

08

09

10

11

12

 

But I get the error above.  Any help will be appreciated.

1 ACCEPTED SOLUTION
Brian_M
Responsive Resident
Responsive Resident

Sorry, you are right!  I used a list of numbers 1..12 in my test, forgot to add back in the Month() function. It should have read

 

= RIGHT ( "0" & Month( [Start Date] ), 2 )

View solution in original post

3 REPLIES 3
Brian_M
Responsive Resident
Responsive Resident

Try 

= RIGHT("0" & [Start Date],2)

Why not use a date table with monthNum field as you specify above and relate the date table to your StartDate column?

Brian_M
Responsive Resident
Responsive Resident

Sorry, you are right!  I used a list of numbers 1..12 in my test, forgot to add back in the Month() function. It should have read

 

= RIGHT ( "0" & Month( [Start Date] ), 2 )

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.