Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
98 | |
91 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |