Replace value based on duplicate column with priority

[Anonymous]

Hi all,

I am currently trying to proccess some raw data into our budget.

I have refined it down as far as i can and as far as i need however as new data gets added i need to replace the old.

The movements are a PO can be APPR from there it will move to CLOSE or CANC. However it wil have a new status date when this status changes from APPR. I need to keep the original status date as this is the months budget this will be coming from, but update the status to CLOSE/CANC. From here if the status is CANC i will filter it out of results.

I have attached a photo for reference.

Is this possible through Power Query?

[ImkeF]

Everytime you refresh a query, all "existing" data will be overwritten by the new data, unless you use the incremental refresh feature in Power BI Premium. 

If you have that or found a way to feed in your historical data as well with the new refresh, you can then group on PO and add a conditional column that checks for existing statuses within the group and adds the fields to filter by.