Forum Discussion

harirao's avatar
harirao
Icon for Post Prodigy rankPost Prodigy
5 years ago

Need to create Vlookup using same table for Monthly comparison

Hi All,

 

Required your assistance, I have connected to sql table, which is having more than 5 months data, need to create 3 columns/Measures doing VLOOKUP for comparison between months
Currently working on data using excel creating tabs for Vlookup, same has to be done in power bi, but i have more 5 months data.
Eg:
Jan data should be Vlookup from Feb data.. so on.. 

Is this option possible in power BI?

Regards,

General Comment
Need Help
Tips and Tricks
Tutorial Requests

3 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    5 years ago

    Hi, harirao 

    I think it is possible to create what you need by Power BI.

    If it is OK with you, please share your sample data, then I can try to come up with the desirable outcome.

    Thank you.

    • harirao's avatar
      harirao
      Icon for Post Prodigy rankPost Prodigy
      5 years ago

      Hi @Jihwan_Kim,

      Not sure how to share file here, sample file i have saved in my google drive, if you can provide email id i can share it.

      Thank you.

  • v-luwang-msft's avatar
    v-luwang-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    harirao ，

    You could share your pbix file through Onedrive for business,and remember to remove the confidential information.

     

    Best Regards

    Lucien