Need to add values to a column ( or create a new one )

[geroagostini]

hi!

 I have a column like the given below and i need to add them a order numbers at the beginnin: 1.New , 2.Created , 3.Old , 4.Recent.

 How can i create a Custom column that does it? 

 Column A

    New

    Old

    Old

    New

    Created

    Recent

    Created

[serpiva64 · Accepted solution]

Hi, 

if that is your only problem you can solve it with a conditional Column

You can also do it step by step with replace if you don't want to create a new column

If this post isuseful to help you to solve your issue consider giving the post a thumbs up and accepting it as a solution

[FreemanZ]

hi @geroagostini 

You may add a calculated column with  DAX code like

Order = 

SWITCH(

    [Column A],

    "New", 1,

    "Created", 2,

    "Old", 3,

    4

)

[Idrissshatila]

Hello @geroagostini ,

You could add a conditional column in power query , check this link for instructions https://learn.microsoft.com/en-us/power-query/add-conditional-column

If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos 👍

Follow me on Linkedin