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

Watch on YouTube

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