Forum Discussion

KimRexh's avatar
KimRexh
Regular Visitor
3 years ago

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 ...
Need Help
InsightsByV's avatar
InsightsByV
Icon for Super User rankSuper User
3 years ago

Hi KimRexh ,

 

You can use "Merge Queries as new" and then add a conditional column like below for comparision:

 

 

 

After clicking OK, Expand ->

 

 

 

Select columns -> 

 

Now, add a conditional column ->

Comparision = if(Merge1Forecast] = Merge1[Actual], 0, 1)

 

Result:

 

 

 

 

 

KimRexh's avatar
KimRexh
Regular Visitor
3 years ago

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?