Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to combine data from two columns in the same row

I want to combine the table Pending Review and Review Auto complete treating them both as Review. And the column values are the count values. I'm not sure how to go about it. Can someone please help me? Thank you.

Note: they are not different columns they are a measure created to give the count of pending review and review auto complete.

 

Need Help
  • TheoC's avatar
    TheoC
    4 years ago

    Hi Anonymous 

     

    You can create a new measure with the two existing measures. Basically, all you are doing is adding the two measures to create the new measure you want.

     

    Review = [Pending Review] + [Review Auto]

     

    Hope this is what you're after!


    Theo

4 Replies

  • TheoC's avatar
    TheoC
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Hi Anonymous 

     

    You can create a new measure with the two existing measures. Basically, all you are doing is adding the two measures to create the new measure you want.

     

    Review = [Pending Review] + [Review Auto]

     

    Hope this is what you're after!


    Theo

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    I want to do it to the other columns as well, but it is not possible to create measures for all of them.

    • TheoC's avatar
      TheoC
      Icon for Community Champion rankCommunity Champion
      4 years ago

      Anonymous can you please be a bit more specific in what you are wanting?  Also, can you provide context to how many columns / tables you're referring to?  Currently, you have only presented two in your post and it's very challenging trying to guess what the problem is.  If you can be more specific and provide more detail, the Community will be able to provide a much more accurate answer.

       

      Thanks in advance.

      Theo