Taking On Access Analytic’s Start Stop Challenge

In this video, Melissa will demonstrate an approach to Access Analytic’s Start Stop Challenge. The ask is to calculate the total number of hours member for a staff member on each month and date. See how you can solve this challenge!

Start Stop Challenge: https://accessanalytic.com.au/power-query-stop-start-challenge

***** Video Details *****
00:00 Introduction
00:55 Dataset
01:11 Filtered rows
03:10 Adding custom column
05:12 Variables
15:30 Projection
16:09 Aggregate values

***** 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 – <a href=”http://www.enterprisedna.co/power-bi-resources” target=”_blank” rel=”nofollow”>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 #PowerQuery #PowerQueryTutorial