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.
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.
THE AUTHOR
Join the email list to get notified when I publish new articles.
Your email address will not be shared with any third-party and will be used exclusively to notify you of new posts.
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.
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 (:
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.
how to use opening balance of month?
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/