Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.