Forum Discussion

Simon_Lo's avatar
Simon_Lo
New Member
3 years ago

Combine two tables

So I have powerbi report , data originates from a SQL server db, in this case a fact table and a couple of dimension tables (dim_object and dim_test). In the report this is visualised as two tables and a couple of slicers and the results look like this ;

 

 

What I actually want in the report  is a combined table that looks like the following and allows for easy comparison (excuse the terrible mockup) .

 

 

Any advice on how to do this gratefully received !

 

many thanks Simon   

No RepliesBe the first to reply