Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi - I am extreamly novice to Power BI, but feel I have self taught myself well at least to this extent anyway. I have one probelm area that I cannot overcome and that is with creating a reationship based on multiple columns. I have two columns "Drv1" and Drv2" in one table called, C51F and "Drv1" and "Drv2" to another table called, Driver Name. The table Driver Name also has a column called, "Driver Names". I'm attemtping to relate Drv1 and Drv2 so that I can report the Driver Name for both Drv1 and Drv2.
Solved! Go to Solution.
The best approach to simplify things would be to unpivot the Drv columns in one or both tables, so you can make a single relationship between the two tables.
Pat
hi @rdstone230
an intuitive way would be to create a new column in both tables with Drv1 and Drv2 in Power Query Editor or with DAX code like:
Column = COMBINEVALUES("-", [Drv1], [Drv2])
hi @rdstone230
an intuitive way would be to create a new column in both tables with Drv1 and Drv2 in Power Query Editor or with DAX code like:
Column = COMBINEVALUES("-", [Drv1], [Drv2])
The best approach to simplify things would be to unpivot the Drv columns in one or both tables, so you can make a single relationship between the two tables.
Pat
Thank you. This was the simplist fix!
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |