Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I have created a third table in query editor to join 2 other tables. However I would like to ignore the case senstive data.
for eg: mdf and MDF, demand Generation & Demand Generation. How do i acheive this and make sure that whenever a user enters the data it records as one entry?
Solved! Go to Solution.
The transformation to UPPER needs to be before you do the Table.Distinct command.
Also, you may need to do a TRIM as well in the Transform menu. You could have "MDF" and "MDF " for example with trailing spaces.
If you still see dupes, do a CLEAN in the Transform menu.
Then do your Table.Distinct() command.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingYou can transform the data using Text.Lower() or use the menu on the Transform tab, Format, lowercase. (or upper if you like.) Then do your comparisons, merges, or show distinct values.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingHi,
I converted the data to upper case. I still do see two values of the data that was incorrectly entered.
and also once convereted to uppercase will i be able to join it to other tables(as they are in normal format).
The transformation to UPPER needs to be before you do the Table.Distinct command.
Also, you may need to do a TRIM as well in the Transform menu. You could have "MDF" and "MDF " for example with trailing spaces.
If you still see dupes, do a CLEAN in the Transform menu.
Then do your Table.Distinct() command.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
83 | |
67 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |