Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I am adding a new column to a table that uses an IF statement. What would the syntax be if I need to run more than one statement if the condition is true? So..,
If a=1, run this statement, then run this statement and even this third statement, else run this
Thanks
Solved! Go to Solution.
Hi @guyinazo
Yes, certainly can. All you need to do is replace the FALSE statement with another IF and continue as such. For example:
Measure or Column = IF ( 'table'[column] = 1 , "ABC" , IF ( 'table'[column] = 2 , "DEF" , IF ( 'table'[column] = 3 , "GHI"....)
Hope this helps 🙂
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
Hi @guyinazo
Yes, certainly can. All you need to do is replace the FALSE statement with another IF and continue as such. For example:
Measure or Column = IF ( 'table'[column] = 1 , "ABC" , IF ( 'table'[column] = 2 , "DEF" , IF ( 'table'[column] = 3 , "GHI"....)
Hope this helps 🙂
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
146 | |
72 | |
63 | |
52 | |
51 |
User | Count |
---|---|
208 | |
91 | |
62 | |
59 | |
56 |