Forum Discussion
Solved
Nested IIF statement in Report Builder linked to SSAS data source
Hi, I am trying to add a calculated member with the following logic - IIF( [Client].[Client Number] NOT IN 028193, 093386, [Client].[Client Type]=62, [Client].[Client Number] IN 028193, 093386). ...
I found what I needed in google search. No need to respond to this post anymore. Thanks.
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! 🙂