My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

Bringing info from unrelated table|Power Query|Excel Forum|My Online Training Hub

You are here: Home / Bringing info from unrelated table|Power Query|Excel Forum|My Online Training Hub

Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search|Last Search Results
Search
Forum Scope



Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
sp_RankInfo
Lost password?
sp_PrintTopic sp_TopicIcon
Bringing info from unrelated table
Avatar
M C

Active Member
Members
Level 0
Forum Posts: 3
Member Since:
January 27, 2022
sp_UserOfflineSmall Offline
1
January 27, 2022 - 3:01 am
sp_Permalink sp_Print sp_EditHistory

Hi, my power query (pq) is calculating all the staff bonuses. The % changes each year. What I want is a table with one line in excel that I can update with the new bonus % and I want my pq to get the % for it's calculations from that.

So, there's no relationship as such, just a cell I can update that will draw into the pq. Does that make sense?

In Excel I'll have

Bonus: 5%

In the power query I want

Person 1 5%

Person 2 5%

etc.

So I can update the 5% and it recalculates for everyone.

Avatar
Mynda Treacy
Admin
Level 10
Forum Posts: 4782
Member Since:
July 16, 2010
sp_UserOfflineSmall Offline
2
January 27, 2022 - 10:15 am
sp_Permalink sp_Print sp_EditHistory

Hi MC,

Load the table containing the bonus value to Power Query, then drill down to the bonus cell: select the cell > right-click > drill down. Then reference that value in a calculated column in the salaries table to calculate the bonus. See example file attached.

Mynda

Avatar
M C

Active Member
Members
Level 0
Forum Posts: 3
Member Since:
January 27, 2022
sp_UserOfflineSmall Offline
3
February 4, 2022 - 1:08 am
sp_Permalink sp_Print

Thank you for the response Mynda! I still can't seem to get it to work, but I need to play around with what you've sent for a little while first. So I'll get back to you! Thanks again!

sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Velouria, Charles Johnson, Riny van Eekelen
Guest(s) 6
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Catalin Bombea: 1944
SunnyKow: 1432
Anders Sehlstedt: 956
Purfleet: 415
Hans Hallebeek: 377
Frans Visser: 351
David_Ng: 318
lea cohen: 248
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Techia Braveboy
Charles Buchanan
Tiago Braga
Rehan Baig
Fred HORVATH
Silke Schmidt
Stuart Barr
Amelia Nolte
David Wier
T P Collins
Forum Stats:
Groups: 3
Forums: 25
Topics: 7154
Posts: 31382

 

Member Stats:
Guest Posters: 50
Members: 34655
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen