Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
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
The syntax of IF is not correct. Please check the one i have provided above.
Thanks
Raj
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"
The syntax of IF is not correct. Please check the one i have provided above.
Thanks
Raj
The syntax your provided above worked perfectly.
Thank you Raj, for all of your help.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |