Forum Discussion

Lebunim's avatar
Lebunim
Regular Visitor
3 years ago

Power Query that 1. Aggregates the Data after each refresh and 2. Creates an entry in new table

Hi Community,

 

I'm trying to create a table that aggregates each refresh by specific column and adds a date.

The Power Query should: 

 

1. Aggregates the Data after each refresh -> I can do that using Group by function. 

2. Creates an entry in new table -> I get entry in my new table but the challenge is: 

 

-> Each time I run a refresh the data gets overwritten, however my goal is to keep track of each refresh so that I can build a trend.

 

Does anyone have an idea how to best deal with that?

As of date will be changing for each refresh... if that makes things easier?

 

 

Need Help

1 Reply

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    3 years ago

    Power BI has no memory* . You need to manage your snapshots in the upstream system. * Yes, there is the self referencing option but that has no safety net.