topic Re: How to create a calculated column with 2 condition in DAX Commands and Tips

How to create a calculated column with 2 condition

njxfoster — Thu, 04 Jan 2024 22:31:19 GMT

Hi everyone!

I want to set up a Calculated column which help me identify "high transfer" and "low transfer"

If "Average Transfer Times" is greater than 30 and "# of Calls" is greater or equal to 15

the Column shows" High Transfer"

If "Average Transfer Times" is less than 3 and "# of Calls" is greater or equal to 50

the Column shows" Low Transfer"

How can I create this calculated Column?

Thanks in advance!

Re: How to create a calculated column with 2 condition

Dangar332 — Fri, 05 Jan 2024 04:25:31 GMT

Hi, njxfoster

Try below

Column=

Switch (

True (),

Tablename[Average Transfer Times]>30 && tablename[# of Calls]>=15,"High transfer",

Tablename[Average Transfer Times]<3 && tablename[# of Calls]>=50,"low transfer")

Re: How to create a calculated column with 2 condition

Anonymous — Fri, 05 Jan 2024 09:18:43 GMT

Hi njxfoster

For your question, here is the method I provided:

Here's some dummy data

Create a column

Transfer Type = IF( 'Table'[Average Transfer Times] >30 && 'Table'[# of Calls] >= 15, " High Transfer", IF( 'Table'[Average Transfer Times] < 3 && 'Table'[# of Calls] >= 50, "Low Transfer", BLANK() ) )

Here is the result

Regards,

Nono Chen

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