Forum Discussion

jlarques's avatar
jlarques
Icon for Helper V rankHelper V
6 years ago
Solved

Create a new column from other column

Dear all, I have a table with many millions of rows and I want to extract a data master to connect it with the budget table.  The DAX formula is: KIT CATEGORY=       DISTINCT(            SELECTE...
Need Help
  • az38's avatar
    az38
    6 years ago

    jlarques 

    modifying data source is the best solution ever 🙂

    do not hesitate to give a kudo to useful posts and mark solutions as solution

jlarques's avatar
jlarques
Icon for Helper V rankHelper V
6 years ago

Hi az38 

thanks for your quick answer.

When I try to create a calculated column on the KIT CATEGORY table, the Concatenated formula cannot show me any table, only the KIT CATEGORY fields, so, I cannot add other external columns from the KIT table.

 

Any ideas?

Thanks again.

az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

jlarques 

no, you should create calculated column in Kit table, in your origin. then create distinct by this new column

do not hesitate to give a kudo to useful posts and mark solutions as solution
Linkedin

  • jlarques's avatar
    jlarques
    Icon for Helper V rankHelper V
    6 years ago

    az38 

    When I create a new column with the DISTINCT formula, an error appears with this text:
    "A table of several values ​​was provided, where a single value was expected".

    Thanks again!

    • az38's avatar
      az38
      Icon for Community Champion rankCommunity Champion
      6 years ago

      jlarques are you sure you do everything correct? maybe you have an empty cells in one of columns?

       

      and be sure, your new table has is defined as

      KIT CATEGORY = 
      DISTINCT(
                KIT[SurrogateKey]
       )

      do not hesitate to give a kudo to useful posts and mark solutions as solution
      Linkedin