cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
marketingVE
Frequent Visitor

How i update the old data?

Hello From Brasil!(So sorry for my bad english)

 

I have a question. 

 

I have a paste with the data in excel:

 

Name       Money         Quality        Data

Mattew     U$ 1,00       Good           01/01

Jhon          U$ 2,00       Bad             01/01

Claudio     U$ 3,00       Medium      01/01

 

If i add in the paste a new table of excel with data:

 

Name       Money         Quality        Data

Mattew     U$ 2,00       Medium      01/02

Jhon          U$ 5,00       Good          01/02

Claudio     U$ 10,00      Good          01/02

 

Power Bi show some thing like that:

 

Name       Money         Quality        Data

Mattew     U$ 1,00       Good           01/01

Jhon          U$ 2,00       Bad             01/01

Claudio     U$ 3,00       Medium      01/01

Mattew     U$ 2,00       Medium      01/02

Jhon          U$ 5,00       Good          01/02

Claudio     U$ 11,50      Good          01/02

 

But, i would like to know how i can merge or combine the rows (or column) based on the LAST update, like that:

 

Name       Money         Quality        Data

Mattew     U$ 3,00       Medium      01/02

Jhon          U$ 10,00      Good          01/02

Claudio     U$ 21,50      Good          01/02

 

It's Possible?

 

1 ACCEPTED SOLUTION
primolee
Resolver I
Resolver I

Hello @marketingVE 

 

Seems that you want to accumulate daily Money to total everytime.

 

I would suggest you do SUM in Power BI report view.  This way you can keep all daily data and pivot any way you want.

 

If you really want to do it in Power Query, you should use Group By.  Group by Name and create SUM of Money and Max of Date.

groupby.jpg

 

Best regards,

David

View solution in original post

1 REPLY 1
primolee
Resolver I
Resolver I

Hello @marketingVE 

 

Seems that you want to accumulate daily Money to total everytime.

 

I would suggest you do SUM in Power BI report view.  This way you can keep all daily data and pivot any way you want.

 

If you really want to do it in Power Query, you should use Group By.  Group by Name and create SUM of Money and Max of Date.

groupby.jpg

 

Best regards,

David

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Kudoed Authors