Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Group 2 calculated Columns

Hi,

 

I have two calculated columns in my report i.e Internally Identified Defects and 

unidentified exception. Is there a way I can combine both the columns and make a 3rd calculated column named Ticket type?

 

 

 

Regards,

Himanshu

Need Help

3 Replies

  • Tahreem24's avatar
    Tahreem24
    Super User
    5 years ago

    Anonymous  share some more context. How would you like to join these two columns? just a concatenate or some logic?

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Tahreem24 

       

      I want to combine the columns so as when I drag my third column i.e Ticket type in my table visual I can see the two columns seperately in my filters.

       

      Is it possible?

       

      I'm trying to make a visual like below:

       

       

       

      Regards,

      Himanshu

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        HI Anonymous,

        Did you mean to create a custom hierarchy with these two fields? If that is the case, you can drag one field to the other, and power bi will combine them to a new custom hierarchy field.
        Regards,

        Xiaoxin Sheng