Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
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 )
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?
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 )
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |