The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
IF-statement in it's simplest form is causing issues.
"Profit" is of datatype "Whole number".
What's wrong here? Running desktop version 2.58.5103.501.
Solved! Go to Solution.
The problem was a missing White-space after "1000".
I have never had any problems with it before..
This works ;o
Hey,
I'm not sure, but do you need to use ";" instead of "," as a separator of arguments?
Check your regional settings at the OS level.
Regards
Tom
if this is calculated measure then 'Sales'[Profit] >1 is comparing a column (multiple values) with scalar, which won't work
this syntax should work fine for calculated column though
The problem was a missing White-space after "1000".
I have never had any problems with it before..
This works ;o
you can have none or multiple whitespaces in the syntax, for sure that wasn't the reason for the measure not working
I agree it does look strange.
But here I have two pictures taken a few seconds ago.
Must be some strange OS-culture bug.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
102 | |
82 | |
62 | |
56 |
User | Count |
---|---|
253 | |
119 | |
115 | |
95 | |
70 |