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,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.