If true then else

[Mederic]

Hello everybody,
I'm stuck on a problem that looks easy but I can't find it.
I'm posting a screenshot with the explanations
Thank you in advance

Best regards

A	B
2	0
2	2
1	0
0	2
0	0
1	1
2	1
3	0
0	0
1	4

[lbendlin]

wrong order of checks.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlLSUTJQitWBsIzALEO4mAFczAAuBpI1hOuAsIxRdCDUmSjFxgIA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [A = _t, B = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"A", Int64.Type}, {"B", Int64.Type}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Result", each 

if [A]>0 and [B]>0 then 1 else 
if [A]=0 and [B]=0 then 3 else 
2
)
in
    #"Added Custom"

[Mederic]

Hello @lbendlin 
Thank you for your reply,
Your result is in a single column whereas I wanted it in 3 additional columns.

Best regards

[m_dekorte · Accepted solution]

Hi @Mederic,

You can use @lbendlin's solution and create a record that can be expanded, to illustrate:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlLSUTJQitWBsIzALEO4mAFczAAuBpI1hOuAsIxRdCDUmSjFxgIA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [A = _t, B = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"A", Int64.Type}, {"B", Int64.Type}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Result", each 
        [Both = null, Not Both = null, Clean = null] &
        (
            if [A]>0 and [B]>0 then [Both = 1] else 
            if [A]=0 and [B]=0 then [Clean = 3] else 
            [Not Both = 2]
        ), type [Both = Int64.Type, Not Both = Int64.Type, Clean = Int64.Type]
)
in
    #"Added Custom"

once expanded, it will yield this result

[Mederic]

Hello @m_dekorte 

Super, thank you very much, it works very well

Best regards