How to add multiple columns within one relation?

Question

Hello,&nbsp;I tried to add multiple columns to a relation, but Power BI doesn't allow it.Is there a way (without making tables for every colomn) to solve this?&nbsp;

davehus · Answer

Hi&nbsp;DaanBos&nbsp;,
&nbsp;
If you unpivot Reports table in powerquery, you should be able to achieve what you need.
&nbsp;
https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c7098
&nbsp;
hope this helps
&nbsp;
Did I help you today? Please accept my solution and hit the Kudos button.
&nbsp;
&nbsp;

daanbos · Answer

Thank you for your answer.But this is not the solution for the problem. Because the unpivot methode create extra rows. (Way to much, because i have already 40.000 rows)

davehus · Answer

Hi DaanBos, Why is the row count a concern. What are you trying to join table two onto? The header or the numerical values in your table?&nbsp;

daanbos · Answer

Hi&nbsp;davehus, im trying to create a relation between the colmns in table Reports and result_ID in abredment_2. So that the numerical values are displayed as text

Forum Discussion

How to add multiple columns within one relation?

4 Replies

Related content

Pivot one column related to multiple columns

Sequential Order column based on multiple criteria

Relate one column to multiples

Filtercontext with date relation

Multiple line and clustered columns chart