Forum Discussion
Case Sensitivity
Power Query is case-sensitive, that's why you can add an index there to protect your sensistivity since Power BI is case-insensitive.
PaulPalkowski Hey,
Kindly refer below webpage.
Power BI: How To Transform Data To Uppercase (quicklylearnpowerbi.com)
or
you can go power query
select column => transform => you can select "capitalize each word"
to get all word as same in your excel.
Thanks
Harish
Did I answer your question? Mark my post as a solution!
no, i want to keep the data as entered... What I shared was only an example. What I have is product assignment naming conventions such as 1524E-PP and 1524E-pp where the PP means it has been inspected and the pp means it has not. The are many variations such as e1487-c is aprototype but e1487-C is and approved part. The letter's case in the hundreds of part numbers represents various stages.
