Forum Discussion

Necrosis1968's avatar
Necrosis1968
Regular Visitor
2 years ago
Solved

Comparing columns error

Hi, sorry first time here and a PowerBI newbie. I want to compare 2 columns, from different tables in PowerBI. They are joined by Unique-ID. I have tried the following: Resolved = IF ('report last...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Necrosis1968 ,

     

    According to your statement, I think your error may be caused that you use 'report this month'[Unique ID] directly in your code to create the calculated column.

    This error occurs because Power BI is unable to determine which row of data to use in a calculation among multiple rows of data.

    Here I create a sample and I can reproduce your issue.

    Last Month:

    This Month:

    Error:

    I suggest you to try code as below.

    Resolved = IF ('report last month'[Unique ID] in  VALUES('report this month'[Unique ID]), "No", "Yes")

    Result is as below.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Necrosis1968 ,

 

According to your statement, I think your error may be caused that you use 'report this month'[Unique ID] directly in your code to create the calculated column.

This error occurs because Power BI is unable to determine which row of data to use in a calculation among multiple rows of data.

Here I create a sample and I can reproduce your issue.

Last Month:

This Month:

Error:

I suggest you to try code as below.

Resolved = IF ('report last month'[Unique ID] in  VALUES('report this month'[Unique ID]), "No", "Yes")

Result is as below.

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Necrosis1968's avatar
Necrosis1968
Regular Visitor
2 years ago

That worked! Thank you so much!