Forum Discussion
How can I join 2 Table Viz need to join.
Hi All,
I have the following 2 tables Visulistations but would like to join them so I am showing the avg values in the top table above the total.
The Month Year is coming from a calculated column in my 'date table' then other columns are meausres I have created.
Any help would be much appricated.
CoCoAndo Fairly certain that you are going to need a disconnected table for your first column then with a singe custom measure. The basic technique is along the lines of this: https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/963588#M428
1 Reply
- Greg_Deckler
Community Champion
CoCoAndo Fairly certain that you are going to need a disconnected table for your first column then with a singe custom measure. The basic technique is along the lines of this: https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/963588#M428