To solve Problem of the Week #10, Haroon demonstrates a technique to calculate the number of customers between a specific date period and also define a start time and end time for the selected date period using only DAX. Time is something that can cause a few hiccups in Power BI, and isn’t always the easiest to manage. However, the number of use cases spans across many industries and scenarios. The model is super simple as its all about focusing on the technique required.
The Problem of the Week initiative is open to members and non-members with the goal to improve Power BI skills through practical application.
To join, you may send your solution to problemoftheweek@enterprisedna.co
***** Video Details *****
00:00 Introduction
00:51 The entries
01:58 Separate the start time & end time
06:10 Bringing in the weekdays
***** Related Links *****
Intro to Problem of the Week #10 - youtu.be/mVG3J-6kQ5M
***** Learning Power BI? *****
FREE COURSE - Ultimate Beginners Guide To Power BI - portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE - Ultimate Beginners Guide To DAX - portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE - Power BI Resources - enterprisedna.co/power-bi-resources
FREE - 60 Page DAX Reference Guide Download - enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership - enterprisedna.co/membership
Enterprise DNA Online - portal.enterprisedna.co/
Enterprise DNA Events - enterprisedna.co/enterprise-dna-events-page/
#EnterpriseDNA #PowerBI #ProblemOfTheWeek #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial #PowerBITimeTable #TimeTable
- Working With Time Tables - Problem Of The Week #10 (DAX Solution) ( Download)
- Dynamic Last N Weeks Trend - Problem Of The Week #5 (DAX Solution) ( Download)
- Perpetual Holiday Calendar - Problem of the Week #1 (DAX Solution) ( Download)
- D4 Products above average price | 25 Days of DAX Fridays! Challenge ( Download)
- 7 Method of calculating Running Total #powerbi #dax ( Download)
- Timesheet & Wages - Problem Of The Week 3 (DAX Solution) ( Download)
- DAX and the Start Date End Date Problem aka Events In Progress ( Download)
- Building relationships between tables when both have duplicates ( Download)
- EXCEL - Hours & Minutes difference between two Dates & Times ( Download)
- 📊 Power BI Case Study: Solving Time Interval Problems with DAX Only ( Download)
- How To Travel Back In Time Using DAX ( Download)
- Excel Pivot Table: How To Add a Percentage Column ( Download)
- Warren Buffet explains how one could've turned $114 into $400,000 by investing in S&P 500 index. ( Download)
- Power BI | #WOW2021 | Week 20 | DAX Tables ( Download)
- Return Working Days in Power BI using DAX ( Download)
