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.
Hi lshelton - what do you mean by "track this data longitudinally"?
Being able to look at data from January, February, March etc. even though in general this is a dashboard that is getting updated with just that month or week's data. They want to be able to see growth or change month by month.
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?