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

Get Demo Files here
ko-fi.com/s/b322c47bbc
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!
/ solutionsabroad
MY FAVOURITE POWER BI BOOKS
📕 The Definitive Guide to DAX - amzn.to/3ruYs2f
📗 DAX Patterns - amzn.to/3oVgOYs
MY GEAR
🎥 Canon 4000D DSLR Camera - amzn.to/3tCqDOw
💻 Cyberpower Wyvern PC - amzn.to/3q04QOw
🪑 Infamous Gaming Chair - amzn.to/3q3iUXw
💡 LED Studio Lighting - amzn.to/3q3ftQz
🎙 Lavalier Microphone - amzn.to/3jwKutG
📺 Monitor - amzn.to/2LuHhhO
GET IN TOUCH
📺 Website - www.solutionsabroad.co.uk
📧 Email me - [e-mail]
🤵 LinkedIn - / solutionsabroad
📘 Facebook - / solutionsabroad
📸 Instagram - / solutions_abroad
🐤 Twitter - / abroadsolutions
🤖 Reddit - / fernanespejo
🌍 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 TH-cam.
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
• Power BI from START to...
🗺 Learn DAX to extend your Power BI calculations
• Power BI DAX Basics OLD
📆 Stay up-to-date on all the features Power BI releases monthly
• Power BI Monthly Featu...
🧪 Get certified as a Microsoft Data Analyst Associate
• Power BI DA 100 Prepar...
💡 Learn Power BI Features to improve your dashboards
• Power BI Feature Highl...
📊 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.microsoft.com/en-us/d...
#PowerBI #DataAnalytics #BusinessIntelligence

[@reynaldomorillo4271]

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

[@MultiCreasey]

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

[@HussainMusic]

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

[@shadowitself]

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

[@SolutionsAbroad]

Thanks Lukasz!

[@sadashivnaik1854]

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

[@Ola-iu6zc]

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

[@ajeyarjun8718]

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

[@rogervandecraen9797]

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

[@donatasmikalauskas447]

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?

[@planningengineer_dataanaly3573]

THANKS FOR SHARING

[@leandrovegacr]

Thanks, very helpful🙂

[@SolutionsAbroad]

Glad it was helpful!

[@isabelrauch3772]

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?

[@baleani1955]

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

[@SolutionsAbroad]

Hi there, as long as the other table has a relationship with your current table, it should be possible!

[@carlosgarciamartinez3380]

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

[@zxmasha]

You are amazing

[@SolutionsAbroad]

Thank you for your kind words, appreciate it!

[@wizardofodz_7778]

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

[@hindyal_masaeed4480]

why i can not use quires on the new generated table

[@sopauljauck4163]

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."

[@texasaurusrex1623]

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?

[@SolutionsAbroad]

Shift enter 👍

[@abdulqadeerkamangar6279]

How to select top 5 count numbers from column?

[@SolutionsAbroad]

here's a video where i covered how to get the TOPN values from a column: th-cam.com/video/vpGAf6Nkt1Q/w-d-xo.html

[@nazmulhaque3894]

Wow

[@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

[@eagillum]

4:45- Add Column

[@goliathstark9142]

BRO TALK ABOUT TO THE POINT MEI BRA BEAUTY