Power Platform Community Forum Thread Details

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?

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

Any idea how to get past this?

Categories:

Power Query

Community site session details

Unable to convert number to Month Name

Helpful resources

News and Announcements

Quick Links

Forum hierarchy changes are complete!

Ajay Kumar Gannamaneni – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Power Apps

Featured topics

Product updates