Forum Discussion
Tracking Growth on Changing Exchange Data
Hi lshelton ,
Based on your description, you need to create a disconnected calendar table as a slicer, and then create a measure to show the differences of the previous months.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Yes, each calendar event has a date attached to it, I was just filtering those dates in Power Query. I sort of understand what you are talking about, but haven't touched calendar tables. Would you by any chance have a link to a walkthrough you like for calendar tables to get me pointed in the right direction?
Thank you, I will give this a try and see how it goes! Appreciate the guidance!
Hmm it doesn't look like a date table would work because there are more than one entry per day sometimes and some days don't have any entries.
Hi lshelton - the Date table / Calendar table is designed for exactly that case. The calendar has all of the dates, and it joins to a key date table on your fact/detail as a Many-to-1 relationship, so it's ok if there are gaps in the detail. You then use the data from the Date table as your longitudinal axis and it automatically filters the detail.
Take a look at this blog post about calendar tables: Time Intelligence Calendar Table
David