Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

DAX query to create new boolean columns

Hello,    I need help with the following DAX query. I am using Power Bi Desktop. I have a table_1 with the following fields   record_ID text record_1 'blablabla' record_2 'bl...
  • Anonymous's avatar
    Anonymous
    6 years ago

    HiAnonymous 

     

    You are looking for a sort of unpivot function to create colunms using DAX. You can do this in m-query, but as far as I know you can't dynamically create columns in dax without some sort of manual intervention.

    Using a measure it is no problem to create your table.

     

    hope this still a bit helpfull.

     

    Jan

     

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Anonymous .

 

Follow  these steps.

 

1. Choose matrix visual.

2. Drag recordId column from table1 on Rows.

3. Drag tag_name column on Columns.

4 . Use the measure suggested by Anonymous on Values.

 

 

Thats all. 

Hope this helps.

 

Appreciate with kudos.

Mark as solution if this resolves your problem.

 

Thanks

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Anonymous 

     

    Easier than I expected 🙂 thanks a lot, very helpful. Not sure about which reply I should mark as solution, but I guess it's the one from Anonymous since he provided the measure.