In this video, Sam showcases a technique that demonstrates the immense analytical power of Power BI and specifically DAX. Here, he shows how to generate multiple ‘what if’ scenarios layered on top of each other. There are many ways that this technique can be of use in various business function or industry that makes this a handy skill in your toolkit.
***** Video Details *****
00:00 Introduction
01:32 Working with three scenarios
03:07 Using HASONEVALUE
04:00 Scenario profits using SUMX
07:06 Arriving at cumulative results
***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – rel=”nofollow”>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://www.enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download – https://www.enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership – https://www.enterprisedna.co/membership
Enterprise DNA Online – http://portal.enterprisedna.co/
Enterprise DNA Events – https://www.enterprisedna.co/enterprise-dna-events-page/
#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial