Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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,
@harirao ,
You could share your pbix file through Onedrive for business,and remember to remove the confidential information.
Best Regards
Lucien
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.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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.
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
104 | |
93 | |
83 | |
64 |