Forum Discussion
Record Daily Data with DAX
Hi, I'm using a file that each day the data is replaced with the latest information at the cut off time. I need to record the data every day to be able to create historical data and charts. ...
OK. There are (at least) two ways to go about this. The easiest by far would be to figure out a way to rename that file so that the file name includes a date stamp and move it into a folder as I suggested. This can for sure be achieved, either by doing it manually, by working the problem at the source (i.e. whatever system produces the file), or by a script that runs every day just after the cut-off. For the last one, if you are not comfortable doing this perhaps you can get help from your IT department.
The second method is much more involved but I have used it successfully. See the below post:
For the scripting suggestion this could be helpful: