Forum Discussion
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?
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.
Best regards,
David
1 Reply
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.
Best regards,
David