Forum Discussion
Powerbi
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.
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"
)
Will this works,?
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.