•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Power Query - Merge column based on from date?
I need help! I'm trying to find a way to match the hours billed to the amount charged. If one table has columns (date, hours), and another table has (hourly rate, from date), how would I get a table that list (date, hours, hourly rate). Right now I write a conditional column, but I don't want to have to manually edit the query every time the rate changes. Thanks
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#real-time data collaboration
#real-time collaboration
#Excel alternatives
#cloud-based spreadsheet applications
#Power Query
#merge column
#date
#hourly rate
#hours billed
#amount charged
#table
#from date
#query
#conditional column
#columns
#match
#manual edit