Forum Discussion
Track Email Workload in a historical table
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...
Hi Alberto,
Do i understand correctly that you want Power BI to add new data to tables when you are refreshing the data?
Hi WilBr, not exactly. What I really want is to save in one table a daily summary of another table that is updated everyday. It is probably better understood with an example:
I have a table "EMAIL" that everyday updates to show the status of the mailbox, with fields: Subject, Send to, Send by, Read (Y/N). This table will be updated everyday at 00:00. What I want is that everyday when "EMAIL" is updated, a new row will be created in another table called "DAILY WORKLOAD". The new row will contain the date, and a count of the number of Read = "Y" from the "EMAIL" table.