Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Power Query, not able to create a relationship saying duplicates but Duplicates /Blank rows dele

Hi Experts I extracted a SQL two tables which are related  Example: Each of the office may or may not be associated with a program  Once I have the list, I wanted to create power query relationshi...
Need Help
  • latimeria's avatar
    latimeria
    4 years ago

    Hi mythbusternz,

     

    Powerquery is case sensitive, dax not.

    You have no dupicates row in powerquery while there are duplicates in DAX.

    User parameter Comparer.OrdinalIgnoreCase or make sure to have same cases ( all upper, First Capitalised, ..)

     

latimeria's avatar
latimeria
Solution Specialist
4 years ago

Hi mythbusternz,

 

Powerquery is case sensitive, dax not.

You have no dupicates row in powerquery while there are duplicates in DAX.

User parameter Comparer.OrdinalIgnoreCase or make sure to have same cases ( all upper, First Capitalised, ..)