Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm having an issue where the FORMAT function for Month is only returning January and December. I originally tried:
SHIP MONTH = format(month('Table'[DATE]), "MMMM")
and was only getting January and December. Then I decided to split the operation. I created a column:
SHIP MONTH NUMBER = month('Table'[DATE])
which produced the correct month numbers for the corresponding dates. I then created:
SHIP MONTH NAME = format('Table'[SHIP MONTH NUMBER], "MMMM")
but alas, I am still getting only January and December. Any ideas on what I am doing wrong here? I don't use FORMAT often, but I feel like my syntax is correct. Thanks in advance for any and all help!
Solved! Go to Solution.
@willclein just get rid of MONTH => Ship Month = FORMAT ( 'Table'[Date], "MMMM" )
@willclein just get rid of MONTH => Ship Month = FORMAT ( 'Table'[Date], "MMMM" )
@Sean I can't believe I didn't realize this was the error. Thanks for your help!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |