New column: Every distinct data value gets multiple values

[thhmez7]

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.

[v-xiaotang · Accepted solution]

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]

Hi,

I cannot enter XYZ at creating table in crossjoin:

2nd argument should be a table again here

thanks again.

[v-xiaotang]

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.