Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by attending the DP-600 session on April 23rd (pacific time), live or on-demand.
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now
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.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Experience the highlights from FabCon & SQLCon, available live and on-demand starting April 14th.
| User | Count |
|---|---|
| 48 | |
| 40 | |
| 37 | |
| 20 | |
| 15 |
| User | Count |
|---|---|
| 70 | |
| 67 | |
| 32 | |
| 27 | |
| 25 |