Remove Duplicates PowerBI

BI and PQ DATA TIPS AND TRICKS

remove duplicates from an individual cell PowerBi

=Text.Combine (List.Distinct(List.Transform (Text.Split([EMAIL],","),each Text.Trim(_))),", ")