The Powerpivot Way – CALENDAR TABLE (Monthly and Weekly Totals) April 19, 2013 by Miguel 5 Comments New Video Up! have you ever wanted to group your aggregations by Month or Week? Check out this video where I use a calendar table to help me make things easier. Facebook Twitter LinkedIn Miguel Posted in:Power PivotTagged with:Powerpivotrelationshipvideoyoutube See more Prev:Someone answered the million-dollar question! (What is Powerpivot?) Back: All Posts Next:Data Explorer & Power View – Using Twitter Data (JSON Format) 5 Comments Siraj Samsudeen April 25, 2013 at 3:18 AM Hi Miguel, Your example is a very good illustration of how PowerPivot can make generation of these kind of reports formula-free for the average XL user. Well done! Your video was getting cut-off at the bottom – is it due to a zoom-setting? Also, for the date filtering, why did you not show the date sliding filter in Excel 2013? One thing that I would have done anytime I generate a pivot table like this is to apply conditional formatting -> Data bars to show a visual impression of how big the numbers are relative to one another. powerpivotisfun April 25, 2013 at 3:28 AM I try to keep these videos as short as possible taking into account that regular viewers of these type of videos only watch it from 4 to 6 minutes top and if it’s something of more length then it’s expected to have more content. Looking in retrospective, I’d have put the conditional formatting and the timeline slicers and even showed more rows in the spreadsheeet but you can just be sure that the upcoming videos will be better (: Siraj Samsudeen April 25, 2013 at 3:30 AM Yes Miguel – you are absolutely correct. I would think twice about watching any video beyond 5 minutes. But with a bit of editing, you could put these things in under 5 minutes. dohere May 27, 2015 at 8:57 PM how to use opening balance of month? Miguel Escobar May 27, 2015 at 9:08 PM Hey! I don’t have an article on that (yet), but the microsoft help article actually brings a really cool example https://support.office.com/en-za/article/OPENINGBALANCEMONTH-Function-DAX-456c8341-6f13-4b9d-bf4a-03958c00e18a Also, here’s some patterns on how to accomplish what you need with some simple CALCULATE tricks https://www.daxpatterns.com/cumulative-total/ Leave a Reply Cancel reply Your email address will not be published. Required fields are marked *Comment Name * Email * Website Notify me of follow-up comments by email. Notify me of new posts by email. This site uses Akismet to reduce spam. Learn how your comment data is processed.