Unable to switch number to month name

[lardo5150]

I am creating a DataFlow in Power Apps.

My Query is pulling from two SPO lists

I have been able to add a column based on the date in another.  This new column is called MonthNumber.

I am trying to convert the month number into MONTH.

I have tried the following:

SWITCH (

    [MonthNumber],

    1, "Jan",

    2, "Feb",

    3, "Mar",

    4, "Apr",

    5, "May",

    6, "Jun",

    7, "Jul",

    8, "Aug",

    9, "Sep",

    10, "Oct",

    11, "Nov",

    12, "Dec",

    BLANK ()

)

and..

Format([MonthNumber],”MMM”)

I keep running into the same error:

Expression.Error: The import SWITCH matches no exports. Did you miss a module reference?

or

Expression.Error: The import FORMAT matches no exports. Did you miss a module reference?

Any idea how to get past this?

[Syndicate_Admin]

Thank you that is it!  

How do I mark your post as the solution?

[AlexisOlson]

There should be an Accept as Solution button next to the Kudos (thumbs up) and Reply button.

If you don't see these options, I can also accept the solution on your behalf.

[AlexisOlson · Accepted solution]

It looks like you are trying to use DAX functions in Power Query, which uses the M language.

Generally, it's easier to get the month string from a date field but you can make the number into a date first:

Date.ToText(#date(2000, [MonthNumber], 1), "MMM")

(The choices of year and day in the #date are arbitrarily chosen.)