Duplicate Columns

[BishwaR]

I have two columns one With Customer Name other With Salary. I need to create duplicates with different names by using DAX.

I used the following dax CALCULATE(MAX(CUSTOMER NAME)) but I was not able to get the exact rows.

CUSTOMER NAME         SALARY        DUPLICATE COL1       DUPLICATE COL2

JOHN                            $3000             JOHN                            $3000

GRACY                          $4000             GRACY                          $4000

AMBER                         $1600              AMBER                         $1600

I do not want to use power query to create these duplicate columns

Thanks

[v-xiaotang]

Hi @BishwaR 

You can try

Measure1 = SELECTEDVALUE('Table'[CUSTOMER NAME])

or

Measure2 = MAX('Table'[CUSTOMER NAME])

or

Measure3 = MIN('Table'[CUSTOMER NAME])

If you want to create a new column, just use the method recommended by tomfox.
If it is in the power query, just click the duplicate column button.

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.

[BishwaR]

Thank you so much for the help

[Nathaniel_C · Accepted solution]

Hi @BishwaR ,
You do not specify, but you can write two measures.
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

Dup Name = Max ('Table (6)'[Name])
Dup Salary= Max ('Table (6)'[Salary])

[BishwaR]

Thank you. But in my actual table names are repeated so when I use MAX some rows are blank.

[BishwaR]

Thank you but in my actual table the names are repeated so when I used the max it is showing some blanks.

How to populate data in the black rows. Thanks

[tackytechtom]

Hi @BishwaR ,

Is it this you are looking for? 🙂

For this I would just create a calculated column and use this code:

DUPLICATE COL1 = 'Table'[CUSTOMER NAME]

DUPLICATE COL2 = 'Table'[SALARY]

Let me know if this solves your issue 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[BishwaR]

Yes I am looking for this but I do not want to use the Power Query Thanks I wanted to achieve this by using DAX

[tackytechtom]

Hi @BishwaR ,

The calculated column code above is DAX. I guess you'd like to have a measure instead 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/