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.
Hello all,
I am trying to extract the month name from a date column and its displaying same as the date.
Here is the code I am using:
DateTimeMonthYear= ADDCOLUMNS(SELECTCOLUMNS(Morale & Workload List,"Date",'Morale & Workload List [Completion time]),"Month", MONTH([Date]),"Month Name", FORMAT([Date], "mmmm"), "Year",Year([Date]))
The issue is for the Month Name column its display same as the date/time i.e. YYYY-MM-DD HH:MM:SS AM/PM
I don't understand why it's not extracting the Month name, can anyone help ?
Thank you.
I just checked the Completion time field with the Date/Time and the format was Text, not Date/Time. As soon as I changed this, its now showing the Month.
@Omar_204 That would certainly cause problems!! 🙂
That's exactly what I am using the same code, so howcome it works here but not on mine. Could it be something to do with the sharepoint list ?
Hello,
Sorry, thats what I have it uses single quotes but still displays the date and time not the Month
@Omar_204 Your syntax looks correct except for not having single quotes around your table name references. I recreated just fine in a PBIX attached below sig.
Hello,
I am having the same issue to extract the Month name from a date/time.
Here is my code:
Any ideas, I checked the column types and they all seem correct.
@Omar_204 What desktop version are you on?
Mine is:
Version
2.108.603.0 64-bit (August 2022)
You could check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues
And if it is not there, then you could post it.
If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".
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 |
---|---|
49 | |
26 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
43 | |
19 | |
18 |