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