Forum Discussion
lcasey
Post Prodigy
Post ProdigyWhy wont the same formula work?
Hello, I have a table I created called countries, it is a simple formula. Countries = Distinct('Transactions'[COUNTRY]) This works perfect--No issues and yes there are multiple AND duplic...
You could do it in Power Query with something like this:
let Source = Transactions, KeptOnlyCountryAndRegion = Table.SelectColumns(Source,{"Country", "Region"}), RemovedBlankCountries = Table.SelectRows(KeptOnlyCountryAndRegion, each [Country] <> ""), RemovedDuplicateCountryandRegions = Table.Distinct(RemovedBlankCountries) in RemovedDuplicateCountryandRegions