Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Greetings,
i want to use if statement in power bi, but i way i'm using it, doesn't achieve the derired.
i want to count the number of new orders for today. if blank return "No New Orders", if true return count(ord_num)
i tried to create a new column:
Solved! Go to Solution.
hI @rawandshoraa ,
Did you try to create a calculated column? My syntax works for measures only 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! |
#proudtobeasuperuser |
hI @rawandshoraa ,
Did you try to create a calculated column? My syntax works for measures only 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! |
#proudtobeasuperuser |
Thank you 🙂
Hi @rawandshoraa ,
I would probably write something like this. Note, I assumed you have a Date dimension called 'DATES'
no_ords = VAR _OrdersToday = CALCULATE ( COUNT ( ords[ORD_NUM] ), DATES[Date] = TODAY() ) RETURN IF ( _OrdersToday > 0, _OrdersToday, "No New Orders" )
Let me know if this helps!
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! |
#proudtobeasuperuser |
Greetings
appritiate your help,
i tried your solution, it gives the following:
Expressions that yield variant data-type cannot be used to define calculated columns.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.