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 ...
Ashish_Mathur
Super User
Super UserHi,
Add a column in each Table with the title of Type. The entries in this column should be Actual and Budget. Append the 2 tables. Select all columns other than the Year columns, right click and select "Unpivot Other Columns". Create a matrix visual - add manager and Role to rows, Type and Attribute to columns. Write this measure
measure = sum(Data[Value])
Hope this helps.