New column that replaces text from existing column with new values

[snocaps248]

I am importing data from SQL and have unpivoted some columns. The columns unpivoted were text columns that referenced the period by month. However the text used is in a rediculous format of FY_01, FY_02, etc. I want these displayed in visuals as month names, January, February, etc... I assume I need to make a new column that references the existing column and changes the text to the proper format. How do I do this? Or is their another way that is more logical?

Thanks

[Pragati11]

Hi @snocaps248 ,

Try following steps:

Consider following column:

Go to Query Editor and extract after delimiter:

 You will get following:

Modify column's data-type to WHOLE NUMBER:

Apply query settings.

Just create a new DAX column as - 

Month Name = FORMAT(DATE(1, 'Month test'[Col1], 1), "MMMM")

You get the required result.

Thanks,

Pragati

[snocaps248]

If I make the changes to the existing column as you suggest, will that break the refresh of data? I have set this dataset to refresh from our on-prem sql nightly for it to update the dashboard for morning execs meeting.

Thanks,

[Pragati11 · Accepted solution]

HI @snocaps248 ,

You can create a DUPLICATE column of your existing column and then follow the steps that I have suggested.

Thanks,

Pragati

[Greg_Deckler]

@snocaps248 - Well, you could write a nested if then else statement in Power Query or you could use a SWITCH statement in DAX like:

Month = 
  SWITCH([Period],
    "FY_01","January",
    "FY_02","February",
    ...
  )