IsHuman or not?

[OlivierSaunier]

Hi,

I'd like to identify accounts that are "probably not human" into a table of accesses, based on their logon ('Audit Accesses'[Logon user]). For that I have a table with a column (Firstnames[name]) containing the firstnames.

So I try this on a calculated column :

IsHuman = VAR result = CONCATENATEX(Firstnames;IF(SEARCH(FIRSTNONBLANK(Firstnames[name];1);" " & 'Audit Accesses'[Logon user] & " ";;999) <> 999;Firstnames[name];""))RETURN IF (result <> BLANK();result;"Probably not human")

Questions :

1. Is it possible to match an exact firstname and not some pieces of it? ie Eddy Collinot is found CollEdEddy

2. How to do the search without matching accented characters? ie Celine Sonut match with Céline

3. Is there a way to do it more quickly?

Thanks for your help, regards,

Olivier Saunier

[mussaenda]

ff

[OlivierSaunier]

@mussaenda What means ff?

Thanks,

olivier

[mussaenda]

Sorry @OlivierSaunier, I should have elaborated it.

I commented ff which means following because I am also looking for an answer regarding your question.

[v-chuncz-msft]

@OlivierSaunier ,

Take a look at this post and try using CONTAINSSTRING. To help improve Power BI, you may submit an idea for accented characters.

[OlivierSaunier]

Hi @v-chuncz-msft 

Still no news from you 🙂 I can't find a way to do this simple thing work :

I have a query "Firstnames" with the first column who contains "firstnames" and want to search each of them into a culomn in another query that contain the fullname.

ie. :

Logon user : Olivier Saunier - firstname : Olivier : true

Logon user : Olivier Saunier - firstname : Olive : false

And if there's a way to manage any match when there's accented characters...

I'm stuck so please if you have an idea I take it.

Thanks

[OlivierSaunier]

Hi @v-chuncz-msft 

Any chan ce to have more details please?

Thanks you

[OlivierSaunier]

Hi @v-chuncz-msft,

Thank you very much for your answer but I'm sorry I've checked your DAX formula with VAR = d but I can't use it in my formula, can you help on how to set the syntax?

I've seen the CONTAINSSTRING too but where do you wan't me to use it? Instead of Search?

How can I provide a sample file on this forum?

Thank you for your help.

Olivier