Forum Discussion
mhq_
5 years agoRegular Visitor
Use Power query to dynamically forecast days used per month on tasks based on startdate and duration
Hello, I am fairly new to M code and have the need to dynamically forecast employee resourcing per month, based on start date and duration of tasks (See below Table). For each row, I would li...
lbendlin
Super User
5 years agoPower Query is a lot of things, but dynamic is not one of them. For what you seem to be trying to achieve Excel formulas seem to be a better fit.