Power Bi Resources, Tips, Tricks, and Updates

  • How To Manage Multiple Date Calculations In Your Fact Tables – Advanced Power BI

    Managing multiple dates in your fact tables in Power BI can sometimes be very confusing when starting out in Power BI. The idea behind this tutorial is to explain the logic and techniques required to get this working correctly in Power BI. You need to get the right relationships and then use the correct DAX formula patterns when managing multiple date calculations. Enjoy Sam ***** 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/ Learn more about Enterprise DNA – http://www.enterprisedna.co/ Enterprise DNA Membership – https://enterprisedna.co/membership

  • Calculate A Monthly Moving Average Year To Date (YTD) in Power BI Using DAX

    In this tutorial we work through how you can calculate the year to date moving average of results in Power BI using DAX. It is common to show the absolute YTD numbers but not the average YTD numbers, so it was a good opportunity to jump into the unique calculation and show you how it can be done. Good Luck Sam ***** 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/ Learn more about Enterprise DNA – http://www.enterprisedna.co/ Enterprise DNA Membership – https://enterprisedna.co/membership

  • Calculate The Last Or Max Value Within A Table Of Data Using DAX In Power BI

    In this tutorial we review how you can work out when the last value from a particular dimension in a table in Power BI. This is quite a unique insight but a relevant one from many pieces of analysis that you might require in Power BI. We work through examples of the MAXX and FILTER functions. These are two important functions in the DAX language that can be used in many situations to extract very interesting insights from your data. Good luck. Sam ***** 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/ Learn more about Enterprise DNA – http://www.enterprisedna.co/ Enterprise DNA Membership – https://enterprisedna.co/membership

  • Detecting and Showcasing Outliers in Power BI – Enterprise DNA Webinar Series

    Gain Access to Resource Download by Registering Here – https://enterprisedna.co/detecting-outliers-in-power-bi-webinar-registration-page/ Workshop Session Topics: – Creating scatter charts and breaking-out outlier results – Comparing customers who are considered outliers versus those that aren’t – Showcasing dynamically how outlier customer groups change over time – Drilling down into what causes outliers through time ***** Learning Power BI? ***** All Enterprise DNA TV Resources – http://portal.enterprisedna.co/p/ente… 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… Learn more about Enterprise DNA – http://www.enterprisedna.co/

  • 5 tips for Power BI Paginated reports

    Get 5 tips for Power BI Paginated reports from Paginated report bear, Chris Finlan and Patrick! These 5 tips can help you on your journey with Power BI Paginated reports. ******** LET’S CONNECT! ******** — http://twitter.com/guyinacube — http://twitter.com/awsaxton — http://twitter.com/patrickdba — http://www.facebook.com/guyinacube — https://www.instagram.com/guyinacube/ — https://guyinacube.com ***Gear*** Check out my Tools page – https://guyinacube.com/tools/ #PowerBI #Paginated #GuyInACube

Share This