Get the month name from fiscal period

[ali_hijazi]

Hello 
got a fact table in which I have the fiscal year and period; the fiscal year starts on April
so in a row of data I might have the following rows with the respective year and period values

2021 1
2021 2
2021 3
....
I want to translate these into 
2021 April
2021 May
2021 June
...
kindly advise

[MayilVahanan]

HI 

You can use Mapping & ApplyMap for this or pick & match function like

Pick(Match(Month, 1,2,3,4,5,6,7,8,9,10,11,12), 'Apr', 'May', 'Jun', 'Jul', 'Aug','Sep','Oct','Nov', 'Dec', 'Jan', 'Feb', 'Mar')

[ali_hijazi]

isn't there any function to do it other than the mapping table?
the thing is that I don't want to modify the script so thought there would be any function and use in the chart

[MayilVahanan]

You can try with Pick & Match function as mentioned in the earlier post

[tresesco · Accepted solution]

You can try like:

=Month(MonthName(Date#(Month,'M'),3))