Forum Discussion

SJHALANI's avatar
SJHALANI
Helper I
3 years ago
Solved

Convert numbers to Months

Hello, I have a column where numbers are written from 0 to 11. Now I want to create a column where 0 should be replaced with the current month, for eg, February, and 1 should be replaced by next mon...
Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    3 years ago

    NewStep=Table.AddColumn(PreviousStepName,"Output wanted",each DateTime.ToText(Date.AddMonths(DateTime.LocalNow(),[Current Column]),"MMMM\'yy","en"))

SJHALANI's avatar
SJHALANI
Helper I
3 years ago

Thanks! This is working. Suppose if I also want to add Year to it the output column, then how can this be done. Reason I now realise I want year is because both 0 and 12 yield the same output "February", however the latter should be February'24

wdx223_Daniel's avatar
wdx223_Daniel
Community Champion
3 years ago

NewStep=Table.AddColumn(PreviousStepName,"Output wanted",each DateTime.ToText(Date.AddMonths(DateTime.LocalNow(),[Current Column]),"MMMM\'yy","en"))

  • SJHALANI's avatar
    SJHALANI
    Helper I
    3 years ago

    Thank you! You are Awesome. I will mark this as a solution.

    However, one last thing - When I build a chart using these Month-Year combination, the axis isn't sorted automatically based on the chrnology of months. Any quick way to do this?
    TIA!

     

    • wdx223_Daniel's avatar
      wdx223_Daniel
      Community Champion
      3 years ago

      you need set "SortBy Column" in the table page, and select the [Current Column]