Forum Discussion
Helper IAnalyze Monthly Changes in a Table
Hi Charcho ,
Apologies for the delay, and thank you for your patience.
I've made some updates to the report based on your feedback. Specifically, I created a new NextMonthKey in Power Query within the Previous Month Data table. Then, I used this to merge with the main table using Student Number and the DateKey (from the current month) and NextMonthKey (from the previous month table).
Please check the attached .pbix file.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Regards,
B Manikanteswara Reddy
Super User
Helper IThank you lbendlin , but the topic seems a bit complex for me to adapt to my example. I have attached the information in this link, in case you can take a look at it. https://www.dropbox.com/scl/fo/9qzy7t1nti2hgt0b2bsnr/AOXdgYX-n0wpPpMvDubjmVk?rlkey=z9g1t839bvk569oyxi550pqdr&st=5jzhc5r4&dl=0
- lbendlin
Please provide better sample data. Your tables are identical, there are no differences.
You may want to consider appending these table with their true dates (no need for year and month columns, that can be done with formatting).
- Charcho
Hello lbendlin , it's a single table. It's available at this link https://www.dropbox.com/scl/fo/9qzy7t1nti2hgt0b2bsnr/AOXdgYX-n0wpPpMvDubjmVk?rlkey=z9g1t839bvk569oyxi550pqdr&st=g4etty7w&dl=0 , and there are indeed differences—the ones I highlighted in yellow in the example.