In Power BI, through DAX we have the ability to combine 2 tables. We can do this using the UNION function.
In Power BI Desktop, select New Table:
We have 2 existing tables, East Region Sales and West Region Sales, with the same number of columns. We will combine the two in a Sales table.
You will see:
Add the code:
The combined table shows data from both tables:
THANKS FOR READING. BEFORE YOU LEAVE, I NEED YOUR HELP.
I AM SPENDING MORE TIME THESE DAYS CREATING YOUTUBE VIDEOS TO HELP PEOPLE LEARN THE MICROSOFT POWER PLATFORM.
IF YOU WOULD LIKE TO SEE HOW I BUILD APPS, OR FIND SOMETHING USEFUL READING MY BLOG, I WOULD REALLY APPRECIATE YOU SUBSCRIBING TO MY YOUTUBE CHANNEL.
THANK YOU, AND LET'S KEEP LEARNING TOGETHER.
CARL
