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

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.