Forum Discussion
Solved
Duplicates
Hello everyone, In Power BI, we have two identical numbers; the only difference is that one of them has a space/tab at the end. In Power BI, the TRIMMED TEXT function and Remove Duplicates do not se...
My suggestion is to first - remove the relationship before editing in Power Query then after performing the next steps listed, recreate the relationship. Then not only TRIM and Remove Duplicates, but to also CLEAN the data using the following entry make sure the CLEAN and TRIM happens before the removal of duplicates as well:
My suggestion is to first - remove the relationship before editing in Power Query then after performing the next steps listed, recreate the relationship. Then not only TRIM and Remove Duplicates, but to also CLEAN the data using the following entry make sure the CLEAN and TRIM happens before the removal of duplicates as well:
