Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Return column name each time specific cell value is detected?

I have a dataset where the rows refer to different people and each colum referers to a different attribute. Each cell has a value of 0 or 1, with 1 indicating that the person has the attribute, and 0...
Need Help
  • v-xicai's avatar
    v-xicai
    7 years ago

    Hi Anonymous ,

     

    you can select the three columns Attribute 1- Attribute 5 in Query Editor, then unpivot these column to row data like picture below, click "Close & Apply".

     

     

     

     

     

     

     

     

     

     

     

    Then create new column1.

     

    Column1= IF(Table1[Value]=1, Table1[Attribute],BLANK())

     

    Finally, you can create calculated table using DAX below.

     

    NewTable = ADDCOLUMNS(SUMMARIZE(Table1,Table1[Person]),"Expected", CALCULATE(CONCATENATEX(Table1, Table1[Column1], " ")))

     

     

     

     

     

    Best Regards,

    Amy

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous ,

 

you can select the three columns Attribute 1- Attribute 5 in Query Editor, then unpivot these column to row data like picture below, click "Close & Apply".

 

 

 

 

 

 

 

 

 

 

 

Then create new column1.

 

Column1= IF(Table1[Value]=1, Table1[Attribute],BLANK())

 

Finally, you can create calculated table using DAX below.

 

NewTable = ADDCOLUMNS(SUMMARIZE(Table1,Table1[Person]),"Expected", CALCULATE(CONCATENATEX(Table1, Table1[Column1], " ")))

 

 

 

 

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    This worked perfectly! Thanks for your assistance.