Excel - DAX Calculation for Month to Date - Using PowerPivot Time Intelligence - Episode 1337
1,580 views · Published 9 February 2011 · 3:15 · Indexed 10 November 2026
Channel: MrExcel.com · 2011 · Education
Microsoft Excel Tutorial: Excel DAX Time Intelligence Functions for Month To Date. Welcome to the MrExcel podcast. In this episode, we will be diving into chapter 11 of PowerPivot for the Data Analyst, where we will be discussing time intelligence. I'm your host, Bill Jelen, and trust me, this one is going to blow your mind. If you watched our previous video on DAX measures, you know that they take into account all the filters applied to a cell. But what if we want to override certain filters? That's where time intelligence comes in. In this video, we will be looking at how to use time intelligence to manipulate our data and get the insights we need. We start off with a table of daily sales, filtered by region, store name, division, and year. But what if we want to see the month-to-date sales? We can easily create a new measure by right-clicking on the table name and selecting "add new measure". We'll call it "month to date sales" and use the calculate function to sum the revenue for the dates in the demo table. But here's the cool part - we can override the filters for the date field, allowing us to see the month-to-date sales for any given period. But it doesn't stop there. The book covers a variety of time intelligence functions such as quarter-to-date, dates in this quarter, dates in this year, and even dates from one year ago. These functions allow us to compare data from different time periods and gain valuable insights. So, make sure to check out chapter 11 for a deep dive into all the time intelligence functions available in PowerPivot. Thank you for tuning in to this episode of the MrExcel podcast. We hope you found it informative and helpful. Don't forget to subscribe to our channel for more tips and tricks on using Excel and PowerPivot. See you next time for another netcast from MrExcel. Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/ Table of Contents: (00:00) PowerPivot Time Intelligence (00:10) Adding a New Measure (00:20) Using DAX Measures to Override Filters (01:05) Creating a Month-to-Date Sales Measure (01:21) Overriding Filters for Date (02:17) Example of Month-to-Date Calculation (02:44) Other Time Intelligence Functions (03:01) Clicking Like really helps the algorithm #excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial This video answers these common search terms: Adding a new measure Beachwood Place Mall, Ohio Daily sales DAX measures and filters Month to date sales Overriding filters for date PowerPivot for the Data Analyst, chapter 11 Time intelligence Time intelligence functions Year 2008 Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153017/
More from this channel
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920