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

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