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

nirvana_moksh's avatar
nirvana_moksh
Impactful Individual
8 years ago

Did you want something like below:

 

Topgunz786123's avatar
Topgunz786123
Regular Visitor
8 years ago

This looks great; however, I want to be able to filter out Current Clients that are in TX or SC or RC. If clients are in TX or SC or RC, I want to use that on the page filter.