Hi There,
Not really sure how best to describe this issue but I will do my best.
Essentially I'm getting weekly reports from a client which looks at the performance of one of the advertising accounts. We're looking at a mix of data from campaign names all the way down to number of clicks and conversions. Within this report there is also a column which specifies the status of said item - Paused, Active & Campaign Paused being an example of what is stated here.
Now I'm currently trying to set up a dashboard which would re-fresh every week after I get the updated report from the client. All other data columns should update fine however I feel as though I will run into issues on the status piece. Is there a way to tell Power BI to only take the most recent status as correct? The status of an item can be changed at any stage during the week by the client so therefore I only want to display to them the current status.
If anyone has any solutions here I would be very grateful.
Kind regards,
David
