Hi, I'm not sure how to pose this question hence my google searches have not returned what I need.
I know how I would do it in excel but stuck on how to do in PBI
I need:
*MON's as start dates // FRI's as end dates (just to add some more complexity
Example:
Close date selected = 1JAN25 + 5months = MON 2 JUN 25...
Buffer = wave 2 onwards would have 1 week buffer to calculate next wave Start dates
thank you!
I know how I would do it in excel but stuck on how to do in PBI
I need:
- user to select a 'CLOSE DATE' from a drop down
- I have another *table with 'WAVE's 1 - 10 and duration of each wave e.g. 3.5 /4.5 /5 etc (this is months duration this may be decimal or whole as some need 'x and half months' and some are just full months)
- Based on CLOSE DATE selected,
- all wave 1's will start 5 months after which should input value to 'START DATE' and add duration which would input value to 'END DATE
- all subsequent wave would then do END DATE (+ 1week buffer) = as start date. + duration to enter end date
*MON's as start dates // FRI's as end dates (just to add some more complexity
Example:
Close date selected = 1JAN25 + 5months = MON 2 JUN 25...
Buffer = wave 2 onwards would have 1 week buffer to calculate next wave Start dates
BUCKET | WAVE | DURATION (Months) | START DATE | END DATE |
A | 1 | 3.5 | MON 2 JUN 25 | FRI 12 SEP 25 |
B | 1 | 4.5 | MON 2 JUN 25 | FRI 17 OCT 25 |
A | 2 | 3.5 | MON 22 SEP 25 | FRI 09 JAN 26 |
B | 2 | 4.5 | MON 27 OCT 25 | FRI 13 MAR 26 |
Any guidance would be appreciated if not, I will do in excel.thank you!