Forum Discussion
Compare two tables in Power BI
Compare two tables in Power BI I have two tables named TableOne and TableTwo. I want to display a table or matrix in my report that will give me all the towns that are in TableOne, but not in Table...
Hello AdamOsmond ,
You can do it in PowerQuery using a simple Mquery code.
Attached is the sample report for your reference.
Thanks
I was able to open it, but I'm new to Powe BI. Can you tell me the steps you did to get the new table? Thank you
Sure.
Go to Power BI desktop --> TransformData
In home --> New Source--> Blank Query
In there, go to Advanced Editor and replace all the code with:
let addedT1_= List.Difference(TableOne[Name],TableTwo[Name]) in addedT1_Advanced Editor:
And your job is done.
Attaching the file here again