Forum Discussion

BishwaR's avatar
BishwaR
Helper V
4 years ago
Solved

Duplicate Columns

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 ...
Need Help
  • Nathaniel_C's avatar
    Nathaniel_C
    4 years ago

    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])

     



Nathaniel_C's avatar
Nathaniel_C
Community Champion
4 years ago

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's avatar
    BishwaR
    Helper V
    4 years ago

    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

  • BishwaR's avatar
    BishwaR
    Helper V
    4 years ago

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