How to compare two columns of a table and get the differences in another column

[WaheedAli]

Hi guys, please bear with me. I am new with Power BI. I want to compare two columns of a table. In each column, within each cell there is another table (multiple values), on both the columns. I want to compare both the columns and create another calculated column, in which I want to get the differences or at least true of false. Attached image will explain it further. Thanks in advance.

[Anonymous]

Hello @WaheedAli,

According to your description, I created some data to show:

1. You must select the expanded icon, expand the table, and display the data in columns and rows before you can compare.

2. Create a calculated column to compare the difference between two columns or at least false.

Difference_column =
var _selectedDepartment= CALCULATE(SELECTEDVALUE(Merge1[Department ID]))
var _selectedProjectId= CALCULATE(SELECTEDVALUE(Merge1[Project ID]))
var _actualDepartment= CALCULATE(LOOKUPVALUE(Merge1[Master.Department ID],Merge1[Master.Project ID],_selectedProjectId))
var _result= IF(_actualDepartment=_selectedDepartment,TRUE(),FALSE())
return _result

3. Result

You can download the PBIX file from here.

Best regards

Liu Yang

If this post helps,then consider Accepting it as the solution to help other members find it faster.

[amitchandak]

@WaheedAli , first you have to expand then as row/columns or maybe as list and then compare and take action.

@ImkeF  , Can you help with this.