Forum Discussion
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?
davehus
Memorable Member
Memorable MemberHi DaanBos ,
If you unpivot Reports table in powerquery, you should be able to achieve what you need.
hope this helps
Did I help you today? Please accept my solution and hit the Kudos button.
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)