Forum Discussion

Topgunz786123's avatar
Topgunz786123
Regular Visitor
8 years ago
Solved

IF / OR Statement

 Good afternoon All,   I wanted to know how to use IF / OR statement for the following:   I have client buckets such as TX, SC, and RC. What I want is if there is a Current Client in TX or a Curr...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi Topgunz786123

     

    Ty this.

     

    Column = IF('AccountAsset-WhiteSpace-GraySpace'[TX]="Current Client" ||'AccountAsset-WhiteSpace-GraySpace'[SC]="Current Client" ||'AccountAsset-WhiteSpace-GraySpace'[RC]="Current Client", "YOUR_VALUE" , BLANK() )

     

    You can apply a page filter on this colun for "YOUR _VALUE".

     

    Thanks

    Raj

  • Anonymous's avatar
    Anonymous
    8 years ago

    The syntax of IF is not correct. Please check the one i have provided above.

     

    Thanks

    Raj

Topgunz786123's avatar
Topgunz786123
Regular Visitor
8 years ago

I tried this:

 

Column = if('AccountAsset-WhiteSpace-GraySpace'[TX]="Current Client", 'AccountAsset-WhiteSpace-GraySpace'[SC]="Current Client", 'AccountAsset-WhiteSpace-GraySpace'[RC]="Current Client", "True", BLANK())

 

but getting the message "Too many arguments were passed to the IF function. The maximum argument count for the function is 3"

Anonymous's avatar
Anonymous
Not applicable
8 years ago

The syntax of IF is not correct. Please check the one i have provided above.

 

Thanks

Raj

  • Topgunz786123's avatar
    Topgunz786123
    Regular Visitor
    8 years ago

    The syntax your provided above worked perfectly.

     

    Thank you Raj, for all of your help.