Forum Discussion

XaviOV's avatar
XaviOV
Helper V
6 years ago

Calculated table with different ID

Hello,


I have a table with different values, questions and answers, and it is grouped by an ID that is random.
How could you calculate these different values in relation to those IDs? That is, I want to differentiate each group of questions / answers by their corresponding ID.

I have attached a screenshot.

Regards,

Xavi



Need Help

2 Replies

  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    Community Support
    6 years ago

    Hi XaviOV ,

     

    If you want to display only the ID and the corresponding questions and answers, we can use following  two ways to meet your requirement.

     

    1. Create a new calculate table using GROUP BY.

     

    Table 2 = GROUPBY('Table','Table'[ID random],'Table'[Question],'Table'[Answer])

     

     

    2. Or we can put them to a table visual.

     

     

    If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?

     

    BTW, pbix as attached.

     

    Best regards,

     

    Community Support Team _ zhenbw

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

    • XaviOV's avatar
      XaviOV
      Helper V
      6 years ago

      Hi v-zhenbw-msft 

       

      I made an example table in Excel that I want to do in Power BI, the "Receta" column will be the column that I will create in Power BI.