Numbers to text and dates

[Anonymous]

I get my data from Mycrosoft Dynamics. How can I change the second and third columns below. 

For the second is fequency: 

if 100000 = quarterly 

if 100001 = six-month 

if 100002 = annually 

For the 3rd column: Each number is a month. 

How can I change

If =1 then January,

if =2, then February and so on.... 

Thanks!!! 

[Anonymous · Accepted solution]

You can add two columns like:

= Table.AddColumn(PriorStepOrTableName, "Frequency", each if [ax_reviewfrequency] = "10000000" then "quarterly" else if [ax_reviewfrequency] = "10000001" then "six-month" else "annually", type text)

= Table.AddColumn(PriorStepOrTableName, "Month Name", each Date.MonthName(#date(1, [ax_annualistheendof], 1)), type text)

--Nate

[Anonymous]

Many thanks @Anonymous  😁

[Greg_Deckler]

@Anonymous Maybe calculated columns like:

Frequency Column = 
  SWITCH([ax_reviewfrequency],
    100000,"quarterly",
    100001,"six-month",
    "annually"
  )