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.
My suggestion would be (instead of doing all of the work in Power Query) to bring the raw/detail/transactional data all the way into the Power BI model and do the calculations/groupings with measures. Since each "transaction" should have a date on it, you can connect to a calendar table and show values plotted against the month/year.
Hope this helps
David
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