Iterating Logic Through Virtual Tables - Advanced DAX Concepts In Power BI

Within this tutorial I wanted to run through an advanced DAX and Power BI topic.

It's all centered around creating virtual tables within you DAX formulas and then iterating logic through these.

Once you can get a strong understanding of how this works, you will quickly see the endless analytical opportunities that open up within Power BI.

It truly does become endless and you can discover really advanced insights fast.

Good luck learning and implementing these techniques.

Sam.

**** Video Details ****
02:29 - Simple Logic Using SUMX
02:58 - Using FILTER For Virtual Tables
05:56 - Using SUMMARIZE For Virtual Tables
07:16 - Using CALCULATE As A Filter

**** Learning Power BI? ****
FREE COURSE - Ultimate Beginners Guide To Power BI - http://portal.enterprisedna.co/p/ulti...
FREE COURSE - Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ulti...
FREE - Power BI Resources - http://enterprisedna.co/power-bi-reso...
FREE - 60 Page DAX Reference Guide Download - https://enterprisedna.co/dax-formula-...
Learn more about Enterprise DNA - http://www.enterprisedna.co/
Enterprise DNA Membership - https://enterprisedna.co/membership
Enterprise DNA Events - https://enterprisedna.co/enterprise-d...

**** Related Links****
Master Virtual Tables in Power BI Using DAX - https://blog.enterprisedna.co/working...
Using Iterating Functions SUMX And AVERAGEX In Power BI - https://blog.enterprisedna.co/using-i...
Working With Iterating Functions In DAX - https://blog.enterprisedna.co/working...

**** Related Course Modules****
Learning Summit Series - http://portal.enterprisedna.co/p/lear...
Advanced DAX Combinations - http://portal.enterprisedna.co/p/adva...
Mastering DAX Calculations - http://portal.enterprisedna.co/p/mast...

**** Related Support Forum Posts****
DAX Virtual Table Logic to modify Context - https://forum.enterprisedna.co/t/dax-...
How can I retrieve a value from a virtual table and place in each row of report - https://forum.enterprisedna.co/t/how-...
Virtual tables and problem with time intelligence DAX functions - https://forum.enterprisedna.co/t/dyna...
For more virtual tables support queries to review see here - https://forum.enterprisedna.co/search...