Retaining values in a table for 7 days

[Vaishali04]

Hi All,

After applying some business logic I created below  tabe in Power Edit Query. Suppose in main table there were 1000 rows but after applying my business logic I got only 3 rows in  final table that I need to display at UI. The requirement is that I need to display below table at UI and need to retain each row for 7 days even if with everday day's refresh that row doesn't come in table as per business logic used and with every day's refresh there can be  new entery of rows. And same 7 days retaining process I need to follow with every new record in table which gets an entry on every day's refresh.

Name	Category	ID
xyz	ac	1
abc	a	2
def	b	3

Is it possible to do this in PBI? 

Please help if someone has knowledge about this.

Regards

Vaishali

[v-lili6-msft]

hi  @Vaishali04 

Sample data and expected output would help tremendously.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

may be you need a date column and use it to filter dataset.

Regards,

Lin

[amitchandak]

@ImkeF , Can you help on this.