topic Re: If one of 2 values is less than 20 in DAX Commands and Tips

If one of 2 values is less than 20

PCStrouble — Thu, 13 Apr 2023 16:39:14 GMT

I have a software that outputs a value in one or two columns.

I have tried to write my own calculate column but always get an error or all zeros.

At any time if value_1 is 20 or above i need the formula to output a 1.

If there is no value_1 but the value_2 over 20 id also need a 1.

The null values i think are whats causing my errors.

Heres what im hoping for.

Value_1	Value_2	Result
Null	Null	0
15	33	0
20	null	1
5	25	0
Null	20	1
30	2	1
Null	19	0
33	Null	1
23	10	1
null	null	0

Re: If one of 2 values is less than 20

PCStrouble — Thu, 13 Apr 2023 16:54:42 GMT

I am by no means a software engineer, coder, at all good with this

Re: If one of 2 values is less than 20

FreemanZ — Thu, 13 Apr 2023 22:01:02 GMT

hi PCStrouble

Try to create a calculated column like:

Column =

IF(

OR(

[value_1]>=20,

[value_1]=BLANK()&&[value_2]>=20

)

Re: If one of 2 values is less than 20

PCStrouble — Fri, 14 Apr 2023 12:23:51 GMT

I think i stated the problem wrong? Im in the "transform Data" section and OR is not being accepted. I am trying to create a custom column to achieve the task

Re: If one of 2 values is less than 20

PCStrouble — Fri, 14 Apr 2023 12:25:17 GMT

Power query editor

Re: If one of 2 values is less than 20

FreemanZ — Sat, 15 Apr 2023 11:51:15 GMT

hi PCStrouble

the previous code is for calculated column with DAX.

in Power Query, please try

1) replace all null with 0

2) create a custome column like:

= Table.AddColumn(#"Replaced Value1", "Custom", each if
[Value_1]>=20 or ([Value_1]=0 and [Value_2]>=20)
then 1
else 0)

it worked like: