topic How to add a most recent table that refreshes as I update my excel sheet. in DAX Commands and Tips

How to add a most recent table that refreshes as I update my excel sheet.

GJeanes1 — Tue, 16 May 2023 16:33:52 GMT

Hello,

I am attempting to create a most recent display (table probably) that shows the most recent incident and displays certain information.

For instance here is some of my data.

while I am trying to achieve something that I have seen in a few ArcGIS dashboards such as this

all the visuals do not matter (such as the dots, clocks, and pins) but the most recent is my main concern.

Re: How to add a most recent table that refreshes as I update my excel sheet.

Anonymous — Fri, 19 May 2023 03:05:33 GMT

HI GJeanes1,

Did your means the old records will been replace/modify with most recent data? AFAIK, current power bi does not include historical data feature. You may need to export these to a temp database and use power bi to getting data from that database.

Regards,

Xiaoxin Sheng