Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!