Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
This nested if calculation DOES work fine, but I have hard time replacing this using SWITC function? I amm affraid that if I have much longer nested calc it might be safer to use switch instead. Can you please show me how would this nested calc (to define products Prod1-Prod16) using my Product from table Query1, could be writen using SWITC function instead. Thanks so much in advance!
Product = if(Query1[PRODUCT]="20","Prod1", if(Query1[PRODUCT]="CC-20b","Prod2", if(Query1[PRODUCT]="21","Prod3", if(Query1[PRODUCT]IN {"31","43","50","53","54","96","98"},"Prod4", if(Query1[PRODUCT]="12","Prod5", if(Query1[PRODUCT]IN {"CC-50b","CC-50d","CC-50n","CC-50p"},"Prod6", if(Query1[PRODUCT]="58","Prod7", if(Query1[PRODUCT]IN {"10","13"},"Prod8", if(Query1[PRODUCT]IN {"65","68"},"Prod9", if(PRODUCT]="CC-60","Prod10", if(Query1[PRODUCT]IN {"42","60","75","99","EXIT"},"Prod11", if(Query1[PRODUCT]="64","Prod12", if(Query1[PRODUCT]IN {"61","RE-61"},"Prod13", if(Query1[PRODUCT]IN {"70","71","73","74"},"Prod14", if(Query1[PRODUCT]IN {"52","8"},"Prod15", if(Query1[PRODUCT]IN {"51","55","82","9"},"Prod16"))))))))))))))))
Solved! Go to Solution.
I believe this would be better done in Power Query using conditional columns. To answer your question, you could use switch/true
=SWITCH(TRUE(),
Query1[PRODUCT]="20","Prod1",
Query1[PRODUCT]="CC-20b","Prod2",
etc
also, use daxformatter.com to make it easier to read.
I believe this would be better done in Power Query using conditional columns. To answer your question, you could use switch/true
=SWITCH(TRUE(),
Query1[PRODUCT]="20","Prod1",
Query1[PRODUCT]="CC-20b","Prod2",
etc
also, use daxformatter.com to make it easier to read.
Thanks a lot Matt! Much apprecite your time and help, and the suggestion to check daxformatter.
Product = SWITCH(
TRUE(),
Query1[PRODUCT] IN {"20"} , "Prod1",
....
Query1[PRODUCT] IN {"31","43","50","53","54","96","98"},"Prod4",
.....
Else statement if needed
)
Product = SWITCH(
TRUE(),
Query1[PRODUCT] IN { "20"} , Prod1,
....
Query1[PRODUCT] IN { "31","43","50", etc} , Prod4,
....
Else statement if needed)
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
77 | |
63 | |
51 | |
47 |
User | Count |
---|---|
212 | |
82 | |
61 | |
60 | |
57 |