Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Loading selective months from previous data files

Hi,   I have a dataset with the Month column which contains data from Jun to Dec 2020. In another file sent, I have the dataset with the same set of columns but for months Apr to Dec 2020 i.e. it c...
Need Help
Show and Tell
Tips and Tricks
  • parry2k's avatar
    parry2k
    6 years ago

    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's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous ,

     

    The blog shared is for transformations to be done on each file that is uploaded from a folder etc.

     

    In my case, I do not want any transformation done on the latest file because I want all the rows and columns from that file as it contains the latest data.


    All subsequent older files that are loaded, I want selective rows to be uploaded based on the latest file i.e. if a certain month rows are not part of the latest file, I want them uploaded, else not.

     

    And as I mentioned previously, I wanted to see if this can be automated without manual intervention, seems it can't.

     

    We can ofcourse do it manually by removing rows that are not needed but the first preference was to automate.

     

    Correct me if I am wrong in my understanding.

     

    Thanks,

    Vishy

    • parry2k's avatar
      parry2k
      Super User
      6 years ago

      Anonymous send me pbix file with sample data and I will put together the solution for you otherwise it is bit hard to explain.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi parry2k ,

         

        Sure, let me try and get some sample data and files together, will send it across and explain the desired outcome.

         

        Regards,

        Vishy