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

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi parry2k ,

         

        Please find the pbix file with sample data loaded in the link below:

        https://drive.google.com/file/d/1BfVAVJs_heORrOhac6sH7RCBEKZ2b_LP/view?usp=sharing

         

        There are 3 data files loaded:

        1. Sample Report Jun to Dec (latest file)

        2. Sample Report Apr to Dec

        3. Sample Report Jan to Mar

         

        The desired outcome is to setup a logic wherein all the rows from the latest file get loaded into the Power BI Model.

        When File 2. gets loaded, only rows from Apr and May should be loaded into the Power BI Model as the latest file already contains rows from Jun to Dec.

        When File 3. gets loaded, all the rows from Jan to Mar should get loaded as the Power BI Data dataset contains rows from Apr to Dec now so there is no overlap in this case.

         

        Please let me know if you have any queries.

         

        Thanks,

        Vishy