Forum Discussion
Trend lines, historic data capture
Hi,
We have a daily excel report sent to us which we display in PowerBi.
One of the feilds that we display on a dashboard is the total number of items in the report.
This changes daily and we want to show trends of this data. (How many more or less since the last data refresh)
is there a way to store a total count value into a new table each time the data is refreshed, along with the time stamp so that over time we can buidl a date vs numnber of items trend line? (As well as other dashboard data / KPI checks)
Thanks,
Hi mayfly ,
If you have premium capability you can have incremental refresh of your data and that would be possible to have all information stored. Assuming that you have only pro licensing, what you can do is to save all the daily files and then making used of the Folder transformation or creating a custom function you can setup the information to get the data from all the files and then being abble to do the trends and so on.
Regards,
MFelix
1 Reply
- MFelix
Super User
Hi mayfly ,
If you have premium capability you can have incremental refresh of your data and that would be possible to have all information stored. Assuming that you have only pro licensing, what you can do is to save all the daily files and then making used of the Folder transformation or creating a custom function you can setup the information to get the data from all the files and then being abble to do the trends and so on.
Regards,
MFelix