Forum Discussion

Helper III

3 years ago

Solved

New Column Measure based on other column

Hi Team ,

Below is my current Table

I want to add another column based on Index collumn

Example : In Index column i have "3" is repeated twice and in Column 1 and 38 is belongs to 3 .

so i need to create 1 more column like 1,38 in another column .

Please hlep me in this ..

Thanks

Arul
Super User
3 years ago
Ayappan ,

try this in measure,

Concat = CONCATENATEX ( VALUES('Table'[Column1] ), 'Table'[Column1], "," )

Thanks,

Arul
- Ayappan
  Helper III
  3 years ago
  Hi Arul
  Thanks for your reply . I need a condition where index is same then other column should get updated .
  - Anonymous
    Not applicable
    3 years ago
    Hi Ayappan ,
    
    Please try:
    
    Column = CONCATENATEX(FILTER(ALL('Table'),'Table'[Index]=EARLIER('Table'[Index])),'Table'[Column1],",")
    
    or
    
    Measure = CONCATENATEX(FILTER(ALL('Table'),'Table'[Index]=MAX('Table'[Index])),'Table'[Column1],",")
    
    Best Regards,
    Gao
    Community Support Team
    
    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
    
    How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
FreemanZ
Super User
3 years ago
hi Ayappan
unable to get the point. Could you elaborate your expectation?