Forum Discussion

DaanBos's avatar
DaanBos
Frequent Visitor
4 years ago

How to add multiple columns within one relation?

Hello,

 

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?

 

Need Help

4 Replies

    • DaanBos's avatar
      DaanBos
      Frequent Visitor
      4 years ago

      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's avatar
        davehus
        Icon for Memorable Member rankMemorable Member
        4 years ago

        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? 

  • DaanBos's avatar
    DaanBos
    Frequent Visitor
    4 years ago

    Hi 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