How to use SELECTCOLUMNS and ADDCOLUMNS to generate new tables in Power BI // Beginners Guide

Get Demo Files here

In this video were going to cover how you can generate DAX tables easily using SELECTCOLUMNS and ADDCOLUMNS in Power BI.

-

🚩 Support us to get perks such as demo files, early access and more!

MY FAVOURITE POWER BI BOOKS

MY GEAR

GET IN TOUCH

🌍 WHO IS SOLUTIONS ABROAD
Hi, my name is Fernan, the one-man band of Solutions Abroad. I work as a Data Scientist based in London, UK and have over 6 years of experience working in Business Intelligence. Solutions Abroad these days is dedicated to teaching the ins and outs of Power BI, through the power of YouTube.

If you want to learn more, I’ve conveniently created playlists to help you find the right topic for you.

🐎 First, watch this video about how a typical Power BI workflow looks like

🗺 Learn DAX to extend your Power BI calculations

📆 Stay up-to-date on all the features Power BI releases monthly

🧪 Get certified as a Microsoft Data Analyst Associate

💡 Learn Power BI Features to improve your dashboards
📊 WHAT IS POWER BI?
Power BI is a business analytics tool by Microsoft. It creates a working environment suited for normal users, meaning tasks such as data extraction, cleansing, analysis and storytelling; these are made easily-accessible to citizen-users, and extendable for technical users. At face value it provides visually-stunning, interactive dashboards, but it’s built on top of so much more.

🔻 Get started with Power BI Desktop for FREE

#PowerBI #DataAnalytics #BusinessIntelligence

[reynaldomorillo]

I always learn and enjoy from your videos. They are clear and easy to understand and follow your demos. Thank You, Reynaldo

[shadowitself]

professional & straight forward
sounds like perfect content :)
thaks!

[HussainMusic]

I always learn from your videos. You're really a great mentor. Thank You.

[MultiCreasey]

Thank you for taking the time to make and to share. This has been really helpful.

[Ola-iuzc]

Thanks for this video. Straight to the point. Please what if the tables are not related, how do we do this? Thanks

[sadashivnaik]

but it was wonderful experience to learn through your video. You are a star

[ajeyarjun]

This is perfect, may i know can you provide any training for power bi dax and data modelling

[baleani]

Thanks and is it possible to use Select Columns for more than 2 tables

[hindyal_masaeed]

why i can not use quires on the new generated table

[carlosgarciamartinez]

Both examples create a new table, how I can do that by only adding a new column to an existing table?

[donatasmikalauskas]

Great video. Thank you.
One question.
For example.
I have table named Dimmensions. One column with values Dimm1 and Dimm2.
And I have another table Sales with columns Dimm1, Dimm2, Sales.

Slicer from Dimmensions was created. Single selection.
What I want to do is create calculated table with columns which depends on slicer.

If I select Dimm1 in slicer than my table would be Dimm1 and Sales
If I select Dimm2 in slicer than my table would be Dimm2 and Sales

Is it possible to achieve with SELECTCOLUMNS?

[isabelrauch]

I want a calculated table which results in the name of staff member per period and then I will calculate their capacity hours. When I use selected columns, it returns multiple values per period per staff member...how can I overcome this?

[rogervandecraen]

hello, thanks for the very well explained video's. recently I struggled with virtual tables as variables to create a measure ( lookup the value from another virtual table variable ) do you offer support for finding a solution.
I need the report with the measure quickly

kind regards
Roger

[sopauljauck]

I got this error message when I tried to add my 2nd column. Can you please tell me how I can get around it? "A table of multiple values was supplied where a single value was expected."

[texasaurusrex]

Super dumb question, but how do you create the new rows when writing dax functions? What key are you hitting to go from 1, 2, 3 rows?

[wizardofodz_]

Hello - what if I wanted to add another table? It won't let me add another related table.

[abdulqadeerkamangar]

How to select top 5 count numbers from column?

[ertertrert]

Thank you my brother for actually showing the fucking step of clicking 'add table' holy fuck

i take back what i said ytou are not my brother you are my lover, i love you my lover

[goliathstark]

BRO TALK ABOUT TO THE POINT MEI BRA BEAUTY