![]() ![]() To change the context, I used the DATEADD time intelligence function to jump back one quarter. I’ve changed the context because that’s what we do inside of the CALCULATE function. I called this measure Sales Last Quarter and calculated the Total Sales. I’ve also created a measure for my quarter-on-quarter sales. Then, I’ll grab my Date, turn it into a table, and get rid of the hierarchy. I’ll start by grabbing my Dates and turning it into a filter so we can focus on a specific time period. I’m going to show you what I mean by a ‘busy’ chart. If you are comparing trends on a daily basis and frequently compare your sales analysis to that of a prior quarter, it could become a very, very busy chart. In this case, we’re comparing quarter-on-quarter trends in sales and margins. I want to dive into this really powerful trend analysis technique where we are able to compare trends. What we’re looking at is a report that I ran through for a workshop at the Enterprise DNA webinar series. Maybe it’s simple calculations you already have, like your sales, cost, or purchases. We are going to dive into how you can create moving averages very quickly around results that you may have already created. Getting The Moving Average From Last Quarter.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |