Forum Discussion
Loading selective months from previous data files
Anonymous solution attached, you can further tweak it as per your need, but I guess this will give you the basic idea.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
Anonymous solution attached, you can further tweak it as per your need, but I guess this will give you the basic idea.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
Thank you parry2k for the help !
Hi parry2k ,
Just 1 follow-up question. The steps given by you surely work and achieve the result.
But given the scenario that the file names would change every month as this data is generated monthly or sometimes even weekly, my understanding is that there needs to be a fixed standard file name such as Current Month, Previous Month and so on so that the Merge and Append operations point to the same dataset name so as to ensure there is minimal to no manual intervention needed.
Is that correct? Please advise.
Regards,
Vishy