Count how many times an ETA date has change

[romoguy15]

Hello, I have a set of data for repair work orders that is refreshed every morning. The data has a column for Ticket Id and a column that shows the tickets ETA. What I am trying to do is when my report refreshes in the morning and the ETA for that repair ticket has changed, I want to count how many times that tickets ETA has changed. Is this possible? So if the date in the ETA column is different from the last refresh, I want to count how many times that ETA has changed. I tried to do this in a calculated column but was unsuccesful 

[amitchandak]

@romoguy15 I think you need to take the help of Dax append process discussed in these two blogs. See if these can help

https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-...
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/

[romoguy15]

I am unsure about this method since my reports are all pulled from outlook excel file. I don't want to keep the old reports stored in my power bi file because the data counts will be way off. I have actually learned quite a few things from Chris Webb's BI Blog which has been very useful. 

I was just hoping to do some type of formula that reads the ETA, and then if the next incremental refresh occurs, and take count of how many times the ETA changed.