topic Re: Less than and greater than value and assigning description in DAX Commands and Tips

Less than and greater than value and assigning description

Anonymous — Thu, 06 Oct 2022 11:41:54 GMT

Hello everyone,

New to the forum and first post. I was wondering which command to use to get the following results in power bi.

I am comparing scores to see if they are less than or greater than a certain range and thus helping with the decision/outome. The excel formula is working, how can i set up the same in Power bi. below is a screenshot showing the formula etc

Re: Less than and greater than value and assigning description

AnkitKukreja — Thu, 06 Oct 2022 15:15:54 GMT

Hi! Anonymous

You can add the custom column and use the below m code to check if it fits your requirements.

= Table.AddColumn(#"Changed Type", "Decision", each
if ( [Speed Rating] > 2.99 and [Speed Rating] < 6.0 and
[Safety Rating] > 2.99 and [Safety Rating] < 6.0 )
then "Commit"
else
if ( [Speed Rating] > 0 and [Speed Rating] < 2.98 and
[Safety Rating] > 2.99 and [Safety Rating] < 6.0 )
then "Consider"
else
if ( [Speed Rating] > 0 and [Speed Rating] < 2.98 and
[Safety Rating] > 0 and [Safety Rating] < 2.98 )
then "Delay"
else "Drop")

Re: Less than and greater than value and assigning description

Anonymous — Sat, 08 Oct 2022 10:46:13 GMT

Thank you Ankit. I will apply above and will let you know the result.

Is there anything special I need to do first if those columns are copied from two different tables?

Re: Less than and greater than value and assigning description

AnkitKukreja — Mon, 10 Oct 2022 08:59:07 GMT

Hi! Anonymous

Nothing major. Just go to Power query into your data table and choose to add the custom column and paste this code. You will get a new custom column based on this code.

Re: Less than and greater than value and assigning description

Anonymous — Mon, 10 Oct 2022 09:27:10 GMT

Hi Anonymous ,

If you want a calculated column:

Decision = SWITCH ( TRUE (), 'Table'[Speed rating] > 2.99 && 'Table'[Speed rating] < 6 && 'Table'[Safety rating] > 2.99 && 'Table'[Safety rating] < 6, "Commit", 'Table'[Speed rating] > 0 && 'Table'[Speed rating] < 2.98 && 'Table'[Safety rating] > 2.99 && 'Table'[Safety rating] < 6, "Consider", 'Table'[Speed rating] > 0 && 'Table'[Speed rating] < 2.98 && 'Table'[Safety rating] > 0 && 'Table'[Safety rating] < 2.98, "Delay", 'Table'[Speed rating] > 2.99 && 'Table'[Speed rating] < 6 && 'Table'[Safety rating] > 0 && 'Table'[Safety rating] < 2.5, "Drop" )

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

Re: Less than and greater than value and assigning description

Anonymous — Tue, 11 Oct 2022 10:00:15 GMT

Thank you Anonymous . I will also try above and will provide feedback. Thank you.

Re: Less than and greater than value and assigning description

Anonymous — Thu, 03 Nov 2022 03:38:00 GMT

Hi Anonymous ,

Any update?

Best Regards,
Gao
Community Support Team