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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
fgnavarrete
Helper II
Helper II

Special character that is not White in Column

Dear, I have a problem and it is shown in the image:

My RUT column has the function of being my primary key and has characters that, Power BI does not make me treat it as a white or null to be able to delete. I've tried to replace, clean, trim, try also with LEN and Unicode as to know what type of character it possesses but I didn't succeed.

Please help, as I do not know how to delete all records that meet this condition. Thank you.

fgnavarrete_0-1598673681109.png

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

@fgnavarrete - When you say LEN and UNICODE below are using the DAX UNICODE and LEN functions? What does Power Query show when filtering? It is strange that it is zero-length, not blank, and the UNICODE value does not exist. Have you tried:

New Table = FILTER('Table',[RUT]<>"")

O

New Table = FILTER('Table',ISBLANK([RUT]) || LEN([RUT])>0)


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

3 REPLIES 3
Greg_Deckler
Super User
Super User

@fgnavarrete - When you say LEN and UNICODE below are using the DAX UNICODE and LEN functions? What does Power Query show when filtering? It is strange that it is zero-length, not blank, and the UNICODE value does not exist. Have you tried:

New Table = FILTER('Table',[RUT]<>"")

O

New Table = FILTER('Table',ISBLANK([RUT]) || LEN([RUT])>0)


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

@Greg_Deckler I did the filter and it worked, I effectively remove the special characters and now the column has all its correct values, there are no longer special characters.

I turned around solving the subject and it didn't occur to me to make a filter that excludes the values from dysint to ""

Thanks a lot.

fgnavarrete_0-1598713790464.png

@fgnavarrete - Awesome, glad you got that solved. Weird one though!


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.