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

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

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?

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

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?

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

You are amazing

Thanks, very helpful🙂

why i can not use quires on the new generated table

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

Wow

THANKS FOR SHARING

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

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

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

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

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

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

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?

How to select top 5 count numbers from column?