Forum Discussion
Sum Array based on Date Range (Date Range Changes per Dimension)
Hi, if someone can help me sum as below, I find it difficult to sum by each project's date range, it may need to use array - I can't get it work. (I posted to Power BI forum as well because that is w...
Hi Hans, sumifs won't work.
This sample data is simple, only has two project in it, so we can point to that specific cell to get that project's time range. But in real data. the Project are hundreds, and the name is like "Timesheet Sept", "Store In the East", random names. So the formula needs to somehow look for the project's start and end date based on its name; then use its start/end date to sum the hours that NOT linked to any project.
Thank you.
Could you attach a small sample workbook without sensitive data that illustrates your problem?