Virtual tables are my personal favorite DAX topic because I think they’re the key to unlocking the full power of DAX. Virtual tables are the only type of tables within Power BI that are fully dynamic, and there are problems that can only be solved by applying virtual table techniques within your measures. For this tutorial, I’m going to share my Top 5 tips and tricks that I’ve accumulated over the years for visualizing, breaking down, and fixing problems with virtual tables in Power BI.
Brian
Links mentioned in the video:
PBIX file use – https://forum.enterprisedna.co/t/pbix-file-for-top-5-tips-for-debugging-virtual-tables-youtube-video/17863
Problem With ALLSELECTED Context at the eDNA Forum – https://forum.enterprisedna.co/t/problem-with-allselected-context/5480
Three Types Of Tables In Power BI And Why The Distinctions Matter – https://youtu.be/an25Huyjo3Q
***** Video Details *****
00:00 Introduction
01:17 The problem
04:15 Tip #1
05:54 Tip #2
10:25 Tip #3
13:34 Tip #4
17:05 Tip #5
18:20 Format DAX measures in a model
***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – http://enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download – https://enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership – https://enterprisedna.co/membership
Enterprise DNA Online – http://portal.enterprisedna.co/
Enterprise DNA Events – https://enterprisedna.co/enterprise-dna-events-page/
#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial #PowerBIVirtualTable #VirtualTable