Unable to convert number to Month Name

Question

I am creating a DataFlow in Power Apps.My Query is pulling from two SPO listsI have been able to add a column based on the date in another.&nbsp; This new column is called MonthNumber.I am trying to convert the month number into MONTH.I have tried the following:SWITCH&nbsp;(&nbsp; &nbsp; [MonthNumber],&nbsp;&nbsp;&nbsp;&nbsp;1,&nbsp;"Jan",&nbsp;&nbsp;&nbsp;&nbsp;2,&nbsp;"Feb",&nbsp;&nbsp;&nbsp;&nbsp;3,&nbsp;"Mar",&nbsp;&nbsp;&nbsp;&nbsp;4,&nbsp;"Apr",&nbsp;&nbsp;&nbsp;&nbsp;5,&nbsp;"May",&nbsp;&nbsp;&nbsp;&nbsp;6,&nbsp;"Jun",&nbsp;&nbsp;&nbsp;&nbsp;7,&nbsp;"Jul",&nbsp;&nbsp;&nbsp;&nbsp;8,&nbsp;"Aug",&nbsp;&nbsp;&nbsp;&nbsp;9,&nbsp;"Sep",&nbsp;&nbsp;&nbsp;&nbsp;10,&nbsp;"Oct",&nbsp;&nbsp;&nbsp;&nbsp;11,&nbsp;"Nov",&nbsp;&nbsp;&nbsp;&nbsp;12,&nbsp;"Dec",&nbsp;&nbsp;&nbsp;&nbsp;BLANK&nbsp;())&nbsp;and..&nbsp;Format([MonthNumber],”MMM”)&nbsp;I keep running into the same error:&nbsp;Expression.Error: The import SWITCH matches no exports. Did you miss a module reference?orExpression.Error: The import FORMAT matches no exports. Did you miss a module reference?&nbsp;Any idea how to get past this?

amitchandak · Accepted Answer

Syndicate_Admin , Try like
Date.ToText(#date(2021,[Column1],1), "MMM")

Forum Discussion

Unable to convert number to Month Name

1 Reply

Related content

Convert text to number

Convert Number to Date

Convert Text to number with DAX

Convert numbers to month

Convert numbers to Months