Forum Discussion

lcasey's avatar
lcasey
Post Prodigy
9 years ago
Solved

Why 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...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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

     

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

It's because you're not creating a new table there. According to your screenshot, you're creating a new column in an existing table (Countries). That's a table formula, not a column formula.

  • lcasey's avatar
    lcasey
    Post Prodigy
    9 years ago

    Thanks, That does make sense now, I need to enter a Single formula to get Countries and Regions. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      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