Compare Datasets using PowerBI

Published on Jan 25, 2020:

In this video, we will learn to compare two data sets using Power BI.
This is very useful to track data changes for data reconcilliation projects.

In the previous video, we learnt to change the default summarisation for a power bi field at a visual level.

Previous Video:NA

Learn Power BI by following this series:

You can download power bi desktop from here.

You can down load the file from the github repository by clicking on this link:

File Name: Compare Datasets using PowerBI.pbix

You can download the dataset from the below link and create your own power bi file.

SUBSCRIBE to learn more about Power BI,Power Query, Power Pivot, Excel,SQL Server and Python!!

Our Playists:

ABOUT DAGDOO:
Website:

Questions? Comments and SUGESTIONS? You will find me here:

Twitter: @dagdooe

Category: Science & Technology
License: Standard YouTube License

[ShabnamKhan-vkfj]

this is pretty cool, didn't know this function existed. Thanks for the quick explanation!

[BobbyFlips]

Thanks for this video. I have an excel report that runs daily and i want to compare the output of today's from yesterday, however there are inserted and deleted records and the order is different. Will this still work?

[Pandy-H]

I really enjoyed this video. A massive help

[shanmukhasrinivas]

Thank you so much brother... Really.. You just made this work simple

[pankaj]

Thanks buddy ! small video but valuable !! cheers!!!

[hotboyphil]

trying to do this getting error about mixing data types

do all the collumn have to the be the same type, i put the same order and names in both tables but i have mixed data

[tavianguyen]

Awesome video. Did not know this function existed. Helped so much in my regression testing, comparing output data sets (legacy and new), versus using Excel and a million functions or pivot tables!