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 have date column based on that i extracted month number
Solved! Go to Solution.
Hi @nagaraj007
Try this
Month = FORMAT(DATEVALUE('Resigned&Removed'[expulsion_date]),"mmm")
Phil
If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.
Proud to be a Super User!
Hi @nagaraj007
Try this
Month = FORMAT(DATEVALUE('Resigned&Removed'[expulsion_date]),"mmm")
Phil
If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.
Proud to be a Super User!
Hi. I don't think you can use format that way. It will format a number to an specific way or a date to an specific way. The thing is you are trying to format a number as a date. If you want the month number you might want to use "mmm" with a Date as the value like FORMAT(Table[DateColumn], "mmm")
Hope that helps,
Happy to 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 |