Forum Discussion

mbailey's avatar
mbailey
Icon for Helper II rankHelper II
3 years ago
Solved

Create Table from difference between two columns in two tables

Hi,   My data sources are two tables that each have a column for a PC's name (Table1.HostName, Table2.DeviceName). I've created measures like the one below to count the differences between the two...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi mbailey ,

     

    The result returned by a measure can only be a scalar, it cannot return table results.

    You may consider using merge queries in the PowerQuery editor.

    Or create a calculated table.

    Table = EXCEPT(DISTINCT('Table1'[HostName]),DISTINCT('Table2'[DeviceName]))

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi mbailey ,

 

The result returned by a measure can only be a scalar, it cannot return table results.

You may consider using merge queries in the PowerQuery editor.

Or create a calculated table.

Table = EXCEPT(DISTINCT('Table1'[HostName]),DISTINCT('Table2'[DeviceName]))

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum