How to add a timesnap in Power Query manually?

[hish]

Hello everyone,

I have a data set with several timesnaps and the according informations. Now I want to add a time snap at 10pm for every day. The information of the other columns for the 10pm time snap should be taken frem the rows before.

For example:

I want to have an addition raw between raw 106 and raw 107 with the time snap at 09.04.2025 22:00:00 | 1 | 20 | 4 | etc.

[lbendlin · Accepted solution]

Power BI has no memory*. You need to do your snapshots further upstream.

* yes, yes, there is self referencing for semantic models. Very Bad Idea.