I am pulling from an underlying dataset that I do not have access to and there is no date/timestamp for the entry of data into this dataset.
I am trying to come up with a way to add one post-hoc in power query, but functions such as fixedlocalnow() still change when I refresh the data source.
What I am looking for is effectively an earliest refresh date for each row of data, as opposed to a latest refresh date.
Normally I can get by tweaking solutions I have found by googling, but I have only managed to find a single person online with a similar problem to mine (from 2022) and they were essentially told it cannot be done.
What I would like to happen is
| data columns | date/timestamp |
|---|---|
| data loaded into PBI on second refresh | datetime2 |
| data loaded into PBI on second refresh | datetime2 |
| data loaded into PBI on first refresh | datetime1 |
| data loaded into PBI on first refresh | datetime1 |
Is what I’m trying to do even possible?
4