Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Gaucho
Helper I
Helper I

Vergleich

Hi could someone please help me here;

Gaucho_0-1674548090725.png

Thanks in Advance

1 ACCEPTED SOLUTION
AlB
Super User
Super User

Hi @Gaucho 

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()

 

SU18_powerbi_badge

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.

 

 

View solution in original post

1 REPLY 1
AlB
Super User
Super User

Hi @Gaucho 

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()

 

SU18_powerbi_badge

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.

 

 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors