Is it possible to create a table that keeps a record of a daily changing measure?

[Mike-Hydrite]

Everyday I get a report that shows me all orders that are shipping late.  The report data is coming in via Exchange connector and with every refresh a new report replaces the old report daily.

One of the measures I have to present is a simple total unshipped count. I've accomplished this by doing using CALCUALTE(DISTINCTCOUNT(etc...  This number shows up on a tile visual in the report.

I'm being asked if there is a way to have Power BI record this daily changing number (refresh from a new report everyday at 5:00 AM) so we can build up a historical database to see which of our shipping locations are struggling to keep up with shipment fulfillment.

The new output table would look like this.

Date of count	Inbound or outbound	Plant	Total count for day
7/9/20	IN	Milwaukee	7
7/10/20	IN	Milwaukee	4
7/11/20	OUT	Milwaukee	6

etc...

I could then use this daily updated and generated table to create a line graph visual to show daily progress for inbound and outbound shipments for plants with the goal to have 0 total count for each day.

[V-lianl-msft · Accepted solution]

Hi @Mike-Hydrite ,

As you said, refresh will override the old dataset.

You can consider creating a dataflow and setting it to an incremental refresh.

https://docs.microsoft.com/en-us/power-bi/transform-model/service-dataflows-create-use 

https://docs.microsoft.com/en-us/power-bi/transform-model/service-dataflows-data-sources 

https://docs.microsoft.com/en-us/power-bi/transform-model/service-dataflows-incremental-refresh 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.