Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Replace value based on duplicate column with priority

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?

Need Help

1 Reply

  • ImkeF's avatar
    ImkeF
    Community Champion
    7 years ago

    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.