Forum Discussion

thhmez7's avatar
thhmez7
Icon for Helper III rankHelper III
3 years ago
Solved

New column: Every distinct data value gets multiple values

Hi,   in an existing table I'd like to create a new DAX column which contains multiple values for an existing field. For example: The new column has the values X, Y, Z. So each Product shoul...
Need Help
Show and Tell
Tips and Tricks
  • v-xiaotang's avatar
    v-xiaotang
    3 years ago

    Hi thhmez7 

    Thanks for reaching out to us.

    >> The new column has the values X, Y, Z. So each Product should get X, Y, Z.

    please try this,

    (1)  create a new table

     

    NEW TABLE = CROSSJOIN('Table',XYZ)

     

    (2) open power query editor, 

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

thhmez7's avatar
thhmez7
Icon for Helper III rankHelper III
3 years ago

Hi,

I cannot enter XYZ at creating table in crossjoin:

2nd argument should be a table again here

 

thanks again.

v-xiaotang's avatar
v-xiaotang
Icon for Community Support rankCommunity Support
3 years ago

Hi thhmez7 

Thanks for your reply.

XYZ is a table name.

 

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.