Hello PowerBI Community,
I hope you're all doing well. I am currently working on a project where we are trying to create a dashboard to track the workload of various departments based on incoming and unread emails. We have connected PowerBI to our Outlook mailboxes using "Microsoft Exchange Online," and we have separate tables for each department containing email data.
The Problem: The challenge we're facing is that every time we refresh the dashboard, we get a snapshot of the current state of emails. However, we are unable to save the number of unread emails to maintain a historical record.
What We Want: We want to create a table that stores the following variables for each department: date, department name, and the number of unread emails.
We have experimented with several approaches but have not yet found a way to automatically append a new row for each department with the current count of unread emails whenever the dashboard updates.
Any guidance or suggestions on how to achieve this in PowerBI would be greatly appreciated.
Thank you in advance for your help!
Best regards,
Alberto
