Forum Discussion

thhmez7's avatar
thhmez7
Helper 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.

v-xiaotang's avatar
v-xiaotang
Community Support
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
Helper 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
    Community 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.