Forum Discussion
Compare two columns in different tables
Hi, I have two disconnected tables (no relationship) that I want to compare. I want to have a slicer to choose the week of comparison. Actual table and Forcast table. I want to have a view like on ...
Thank you for your reply!
When I do this I get a new row for each row when I expand the table with columns from table2.
Also, I have tried creating field parameters for the columns so that I can create a slicer for the columns but is there a alternative way of creating slicer with column header?
amitchandak
Super User
Super UserKimRexh , a better way is to create common dimensions and use those
Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
Power BI- Power Query: When I asked you to create common tables: https://youtu.be/PqfGW6pl1Sw