Add an instance on refresh data

[Anonymous]

Hi,

I wanted to make a dashboard where i am updating today's data as below

Sales as on Today (22-Apr-2021)
Product	Sales
Television	250
Mobile	475

and I wanted to make a chart of Last five days as data mentioned below

Sales of last five working days
Date	Television Sales	Mobile Sales
21-Apr	220	500
20-Apr	150	425
19-Apr	270	390
18-Apr	320	450
17-Apr	190	360

I wanted to automate, When i refresh the first chart, Value of First chart/Table should add in table of Second chart for next day.

Sales of last five working days
Date	Television Sales	Mobile Sales
22-Apr	250	475
21-Apr	220	500
20-Apr	150	425
19-Apr	270	390
18-Apr	320	450

There are chance that data has not updated correctly..So I need to verify the same once its ok..it should push to second table.

Is there any possibility that i can export it to excel.Because if i refresh first chart two/three time it will add instance in second table. So i can modify that table..I mean interactive excel?

[Anonymous]

@Anonymous 

Your requirement cannot be achieved with Power BI, refresh in Power Bi is just refresh the dataset and update to the newest data for source. The expected automation is not supported and unlikely to be included in the future updates.

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , for last 5 days you can have measure like this

New measure =
var _max = today() // maxx(allselected('Date', 'Date'[date])
var _min = _max -5
return
calculate(sum(Table[Sales]), filter(all('Date'), 'Date'[date] >=Min && 'Date'[date] <=_max && Date[Date] <=max(Date[Date])))

date on axis, product on legend as per need