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! 🙂
