Solved: Adding Rows to a Table from Another Table - Page 2

Omar1 · ‎05-16-2018

I'd like to create an Account Activity table that shows every activity from each account to it. Currently, I have an Account table where it shows only the latest activity. The Account table gets updated on a daily basis. Ideally, I'd like to add the latest account activity from the Account table to the Account Activity table as an individual row.

Example:

- Monday: Account #123 added 3 contacts

- Tuesday: Account #123 added 4 contacts

The Account table in the latest refresh would show the last activity as "added 4 contacts"....I'd like to have the Account Log table show both rows.

Is that possible in Power BI? If so, how?

Thanks!

parry2k · ‎05-17-2018

Nope, I guess with some R code this can be done but I don't think PowerBI is used to write back. You have to work on database end to take care of this.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

View solution in original post

Adding Rows to a Table from Another Table

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024

How to Get Your Question Answered Quickly