Calculated table with different ID

[XaviOV]

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

[v-zhenbw-msft]

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]

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.