DAX Fridays #201: How to create virtual tables using DAX

In this video I will show you how you create virtual tables in DAX to do calculations on them.

Happy Friday!


SUBSCRIBE to learn more about Power and Excel BI!

Our PLAYLISTS:

☼☼☼☼☼☼☼☼☼☼

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:

▼▼▼▼▼▼▼▼▼▼

If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:


Many thanks in advance!

▲▲▲▲▲▲▲▲▲▲


************





************


QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Twitter ► @curbalen, @ruthpozuelo

#CURBAL #SUBSCRIBE

[Phoenixspin]

"Without having to do any Black Magic in Dax." I honestly think of Dax as magic, not a joke. It does thing my Excel mind didn't even know were possible. It bends my consciousness in ways I didn't know it could be bent. Please, let's keep Dax mysterious. Don't try to take the Black and Proud magic out of it. I watch you because I want to perform the impossible, not just master the possible. Please, I want to feel special. I want to do things the average person can't do. You are so brilliant that you confuse magic with the mundane.

[RobertoStaltari]

When you use virtual table in DAX you are a step ahead. Thanks Ruth! (BTW who can give a thumb down?)

[mohammadakhtarjadhakhan]

Hello Ruth.
This has been a real life saver.
Has been stuck on this problem for several days and then you just saved my day.
Keep up the good work 👍

[dannyhometown]

Hi Ruth, that's magic. The virtual tables are always my pain point. Appreciated for your demo and sharing. Really good one. 🎉🎊🥇

[walidhome]

Thank you very much for your effort; you are exceptional.

[jorgeeduardomoltenimoreno]

Very clear example of virtual tables super powers!

[benignoguilarte]

Hi Ruth, I love your videos.. My life-work is so easy since I been following your channel 3 year ago. You just made my day Thanks!!

[malateshhkulkarni]

Hi Ruth, It is a great video..one of many masterclasses - certainly your videos are magic for me :)

[jray]

Thank you for the quick and insightful video — Good job!

[ameyraj]

Loved the video thumbnail❤❤Virtual Tables

[gj]

I really like your personality! Special you are learning new things.

[TheChefrent]

Good Video, but you could also add Student Value again and then switch to Distinct Count, same result.

[jaymehta]

Instead of count of the overall grade, we could have used the unique count of Students column itself no? It would have given 1 and 2 in the second column.

[prateeksrivas]

I just can't thank you enough for using an example that resembles my dataset. I need to have more complex column such as percentages and everything though. But the logic is cool. Lovely

[krishanzoa]

Hi Ruth! this was a great instruction which I tested. How can we create a measure to create a virtual table to display or grab certain columns of a table.
After watching your summertime & summerizecolumns video I realized it is not possible as we have to add an expression for the function to work in DAX. Any suggestions?

[abhishek]

Thank you . Learning with your video is super fun.

[RonaldPostelmans]

Hi Ruth, Can you tell me what the difference is between Summarize and Calculate table?

[parassharma]

Hi, Thx for the video. What if instead of column, we have a measure that we are seeking count of. It cant be summarized in table as its a measure?.Could you suggest how to get a count of measure?

[SS-lvpn]

So what if instead of count, I need to select a column from virtual table and return the same, how can we do that ??

[jameskim]

Best lecture I ever had :) But I need your help, is it possible make a virtual table from another table in Power Pivot in excel not in Power BI? I only can find make a blank table