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

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