Forum Discussion

hish's avatar
hish
Frequent Visitor
1 year ago
Solved

How to add a timesnap in Power Query manually?

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.

  • 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.

1 Reply

  • 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.