I'm new to PowrPivot/DAX and would like some help/pointed in the right direction
I have a table of activities and wanted to apply a filter from a separate calendar table so that the total duration for all activities for that day is shown
Activity Start Date/Time Finish Date/Time
Activity A 12/10/2014 14:33 12/10/2014 15:23
Activity B 12/10/2014 15:23 12/10/2014 16:00
Activity C 12/10/2014 16:00 13/10/2014 16:11
Activity D 10/10/2014 12:00 13/10/2014 12:00
i.e. a filter applied for 12/10/2014 would show duration for Activity A, B and the portion of C that falls on the 12th, and also the 24 hours from Activity D
Appreciate any guidance/help
I have a table of activities and wanted to apply a filter from a separate calendar table so that the total duration for all activities for that day is shown
Activity Start Date/Time Finish Date/Time
Activity A 12/10/2014 14:33 12/10/2014 15:23
Activity B 12/10/2014 15:23 12/10/2014 16:00
Activity C 12/10/2014 16:00 13/10/2014 16:11
Activity D 10/10/2014 12:00 13/10/2014 12:00
i.e. a filter applied for 12/10/2014 would show duration for Activity A, B and the portion of C that falls on the 12th, and also the 24 hours from Activity D
Appreciate any guidance/help
