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

Anonymous's avatar
Anonymous
Not applicable
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

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.