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.⚡

parry2k's avatar
parry2k
Super User
6 years ago

Anonymous I cannot perform any power query steps, I need these 3 excel files as well or you should create data table directly in the power bi rather pointing to excel file.