Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Add an instance on refresh data

Hi,

 

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

 

Sales as on Today (22-Apr-2021)
ProductSales
Television250
Mobile475

 

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

 

Sales of last five working days
DateTelevision SalesMobile Sales
21-Apr220500
20-Apr150425
19-Apr270390
18-Apr320450
17-Apr190360

 

 

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
DateTelevision SalesMobile Sales
22-Apr250475
21-Apr220500
20-Apr150425
19-Apr270390
18-Apr320450

 

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?

Need Help
Tutorial Requests

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    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

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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.