Identifying Duplicates by not taking Case Sensitivity into consideration - Power BI/Power Query

[smpa01]

Hi ,

Is there a way Power BI can identify entries in a column as duplicates by taking into consideration the case sensitivity of the entires. I have attached a screenshot of what I want Power BI to achieve.

Thank you in advance.

[vanessafvg · Accepted solution]

@smpa01 right, so you dont want it to take the case sensitivity into account you mean?

there are 2 ways of dealing with this

if you going to work it out in power query (m) then change all text to either upper or lower case

if you going to do it in dax (which ignores it)  just do a count unique = distinctcount(columnname) and place the value and the measure in your visual.  dax will ignore the different cases