Forum Discussion

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 should get X, Y, Z.

Thank you.

Tips and Tricks

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.

3 Replies

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
  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
    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.

Related content