Follow a parameter coming from different dataset each month

[JeanCG]

Hello,

I am trying to find a workaround and looking for suggestions in the following case:
- The same file, with the same structure, is refreshed let's say every month
- I perform the same calculations on it, same ratios, etc.

- I cannot get it "as a database", e.g. I cannot get the same file with a "Month" and "Year" column, so I'm forced to use every single file, each month

How would you manage to follow a calculated value over time, for instance plotting it? Is Append the best way to solve this, by modifying the DAX Query and adding a new file each month, and adding the Month and Year values by hand?

Or did I miss something?

Thank you,

JeanCG

[mwegener · Accepted solution]

Hi @JeanCG ,

Import the files as a folder and use the file name to extract a year and month column.

[JeanCG]

Hi mwegener, I did'nt know this solution, but it's definitely the best workaround. It works like a charm.

Thank you very much.