This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is upgrading! Read all of the details including the timeline and what you can expect. Learn more
Hi @Anonymous
You are comparing [HilfsKonto] = 0 [HilfsKonto] = "" , ie, comparing to text and number. One of them is wrong; a column can only have one data type and comparisons only make sense between the same data type.
What type is [HilfsKonto]? You might have to change it.
If you don't, you'll either need [HilfsKonto] = "0" or [HilfsKonto] = BLANK()
|
|
Please accept the solution when done and consider giving a thumbs up if posts are helpful. Contact me privately for support with any larger-scale BI needs, tutoring, etc. |
Hi @Anonymous
You are comparing [HilfsKonto] = 0 [HilfsKonto] = "" , ie, comparing to text and number. One of them is wrong; a column can only have one data type and comparisons only make sense between the same data type.
What type is [HilfsKonto]? You might have to change it.
If you don't, you'll either need [HilfsKonto] = "0" or [HilfsKonto] = BLANK()
|
|
Please accept the solution when done and consider giving a thumbs up if posts are helpful. Contact me privately for support with any larger-scale BI needs, tutoring, etc. |
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.