Is UNIQUE() case sensitive

[sarvagnag]

Is UNIQUE() case sensitive? I can see duplicate values which have different uppercase and lowercase letters of the same word.

[dbaum]

Sounds like it is.

[Aurelien · Accepted solution]

Hi @sarvagnag 

If your UNIQUE() expression applies to a list from a column and you would like to avoid these duplicate values, you may want to:

1) add a new virtual column "lower_case" with expression

LOWER([yourColumn])

2)try 

UNIQUE(yourTable[lower_case])

[sarvagnag]

Thank you both!