Hi guys
So, my email marketing platform aggregates daily send data, rather than displaying what was sent on which day making performance reporting difficult.
On Monday, 5 emails would be sent. On Tuesday, 6 emails will be sent. BUT, in aggregate fashion, it will display the total results for Tuesday = 11.
I need to be able to use a PowerQuery function that will take:
(Todays send data) - (Yesterdays send Data) = Todays send
And this query MUST be already set and ready for Wednesdays set of data.
Thanks!
So, my email marketing platform aggregates daily send data, rather than displaying what was sent on which day making performance reporting difficult.
On Monday, 5 emails would be sent. On Tuesday, 6 emails will be sent. BUT, in aggregate fashion, it will display the total results for Tuesday = 11.
I need to be able to use a PowerQuery function that will take:
(Todays send data) - (Yesterdays send Data) = Todays send
And this query MUST be already set and ready for Wednesdays set of data.
Thanks!
