Forum Discussion
Solved
Generating a table with values for all dates between two dates
I've got data that relates to the amount of money given to research grants, which each have a start and end date. I have a table that looks like this: ResearchGrant Award total Award start ...
I need to do something similar in a report I have. In Power Query, transform the overall grant amount into a daily amount first, then use this sort of formula:
= Table.AddColumn(#"Some Previous Step Name", "Date", each List.Dates([Award Start], Duration.TotalDays([Award End]-[Award Start])+1, #duration(1,0,0,0)))
Then expand the list
I need to do something similar in a report I have. In Power Query, transform the overall grant amount into a daily amount first, then use this sort of formula:
= Table.AddColumn(#"Some Previous Step Name", "Date", each List.Dates([Award Start], Duration.TotalDays([Award End]-[Award Start])+1, #duration(1,0,0,0)))
Then expand the list
jthomson Is there a way to get workdays minus the holidays for this?