Store data from visual and connect with date and time

[rayvensen]

Hi all, im new to this community

I'm struggling with following and i can't find any solution in the community.

I have data which i import from a csv. The csv refreshes every hour. From this csv i calculate various summs of total warehouse worth and total warehouse part count. The "live" data works fine.

Now i want do bring this data in relation with date and time, so i can show a trend over time.

The csv don't have any time informations.

My idea is, that a can store the calculated summs in a new table with a date and time. So i can afterwards use this new table for a new visual.

Unfortunately i have no clue how to solve this.

Any ideas out there...

Thanks

[rayvensen]

Thanks mate...

[amitchandak · Accepted solution]

@rayvensen , DAX append is solution dicussed in these blog. If you can add fixeddatetime in power query and append

Check

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/