Forum Discussion
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 Current Client in SC or a Current Client in RC, to produce a value. If there isn't a Current Client in either of the three buckets, to produce a value of none / blank.
I tried this but it didnt' work:
Column = if('AccountAsset-WhiteSpace-GraySpace'[TX]="Current Client", OR('AccountAsset-WhiteSpace-GraySpace'[SC]="Current Client", OR('AccountAsset-WhiteSpace-GraySpace'[RC]="Current Client")))
Is there an easy way to do this?
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
6 Replies
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
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"
Did you want something like below:
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.
