Forum Discussion
Nested IIF statement in Report Builder linked to SSAS data source
I found what I needed in google search. No need to respond to this post anymore. Thanks.
Can you give some example rows for what your calculated member should be? I'm not clear even what data type you intend to return (boolean/integer/text).
FYI, this is not DAX but expressions written in Microsoft Visual Basic.
I need something like this returned. Client numbers, to be specific.
P.S.: that is good to know it is not DAX and MVB instead. Thanks! 🙂
| Client | Subsector | Client Type |
| 28193 | Education | 62 |
| 26203 | Pharmaceuticals | |
| 216340 | Marijuana Producers | |
| 83258 | Nondurable Household Products | |
| 93386 | Education | 62 |
| 85516 | Food Products | |
| 212315 | Medical Supplies | |
| 26389 | Education | 62 |
| 63511 | Legal Services | |
| 211931 | Medical Supplies | |
| 210124 | Biotechnology | |
| 212809 | Pharmaceuticals | |
| 208198 | Medical Equipment & Services / Medical Supplies (20102015) | |
| 213387 | Chemicals / Chemicals: Diversified (55201000) | |
| 200700 | Personal Products | |
| 19427 | Medical Supplies | |
| 13670 | Medical Equipment | |
| 23685 | Specialty Chemicals | |
| 211480 | Chemicals / Chemicals: Diversified (55201000) | |
| 25416 | Specialty Chemicals | |
| 217553 | Chemicals / Specialty Chemicals (55201020) | |
| 92012 | Education | |
| 217522 | Chemicals / Specialty Chemicals (55201020) | |
| 20871 | Education | 62 |
Hi MBBIUser
Use this code to add a new column:
Client Type = If(Client[Client] in {28193,93386,26389,20871},62,blank())Output:
ADD Calculated column: https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-tutorial-create-calculated-columns
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/I can't use this because I am in the report builder not desktop. But thank you! 🙂
