Powerbi

[AtchayaP]

  I want to know dax syntax for calculating job range in PowerBI .  I have highlighted the column that is the answer should I need in PowerBI   @Vijay_A_Verma 

[Vijay_A_Verma]

Use below DAX. Replace Range with your result column name and Years with your input column name

Range = 
SWITCH(TRUE(),
    [Years]>5,"5 years",
    [Years]>3,"3-5 years",
    [Years]>1,"1-3 years",
    "<1 year"
)

[AtchayaP]

 Will this works,?

[v-stephen-msft · Accepted solution]

Hi @AtchayaP ,

It's the Power Query forum, we use the M language instead of the DAX language in the Power Query Editor.

They are different, you can refer to Differences between the M Language and DAX in Power BI.

The screenshot you provided is in the Power Query editor.

You can add the conditional column as

Here's the result.

You can go to the advanced editor to check you codes.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.