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.
Solved! Go to Solution.
Hi @timward10
"" is a "white space" in which the data type is a text...
Try to modify the formula to
Column = if(isblank(or('Opps+Products - Revenue Probability'[Contract Length (months)]),'Opps+Products - Revenue Probability'[Contract Length (months)]=0),12,'Opps+Products - Revenue Probability'[Contract Length (months)])
OR
Column = if(or('Opps+Products - Revenue Probability'[Contract Length (months)]=blank(),'Opps+Products - Revenue Probability'[Contract Length (months)]=0),12,'Opps+Products - Revenue Probability'[Contract Length (months)])
if it won't work
Please share sample data (excluding sensitive information) in text format, along with your expected result and any relevant logic. For guidance, refer to
How to provide sample data in the Power BI Forum
If possible, upload a simplified .pbix file using this guide:
How to upload PBI in Community
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Hi @timward10
"" is a "white space" in which the data type is a text...
Try to modify the formula to
Column = if(isblank(or('Opps+Products - Revenue Probability'[Contract Length (months)]),'Opps+Products - Revenue Probability'[Contract Length (months)]=0),12,'Opps+Products - Revenue Probability'[Contract Length (months)])
OR
Column = if(or('Opps+Products - Revenue Probability'[Contract Length (months)]=blank(),'Opps+Products - Revenue Probability'[Contract Length (months)]=0),12,'Opps+Products - Revenue Probability'[Contract Length (months)])
if it won't work
Please share sample data (excluding sensitive information) in text format, along with your expected result and any relevant logic. For guidance, refer to
How to provide sample data in the Power BI Forum
If possible, upload a simplified .pbix file using this guide:
How to upload PBI in Community
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Thank you so much @Ritaf1983 that has worked straight away, and the explanation makes perfect sense! Thank you again.
Happy to help 🙂
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 |
---|---|
140 | |
71 | |
64 | |
52 | |
50 |
User | Count |
---|---|
209 | |
92 | |
62 | |
59 | |
56 |