Column update

[Anonymous]

Hi and nice to meet you,

I have two excel files which are Table1 and Table 2 as shown.

May i know how can i update the "cost" column in table 1 according to the invoice id in table 2 automatically?

Thank a lot!

Monlight

[speedramps · Accepted solution]

Hi monlight

I am not sure what you mean by "update". 

Powe Bi is read only. If you want to update the excel sheet then try use Power Flow.

However, in Power BI Power Query you can merge the 2 sheets into 1 sheet with a Cost1 and Cost2 value.
The add a conditional column Cost = If Cost2 is null then Cost1 else Cost2.

Click here to see how to combine queries 

I am an unpaid Power BI volunteer. Please click the thumbs up if you like me trying to help. Then click solved if this fixes your problem. Thank you.

Warm regards, speedramps

[speedramps · Accepted solution]

Hi monlight

I am not sure what you mean by "update". 

Powe Bi is read only. If you want to update the excel sheet then try use Power Flow.

However, in Power BI Power Query you can merge the 2 sheets into 1 sheet with a Cost1 and Cost2 value.
The add a conditional column Cost = If Cost2 is null then Cost1 else Cost2.

Click here to see how to combine queries 

I am an unpaid Power BI volunteer. Please click the thumbs up if you like me trying to help. Then click solved if this fixes your problem. Thank you.

Warm regards, speedramps

[Anonymous · Accepted solution]

i think this is useful solution, thanks speedramps, appreciate with all of your effort!😀