none
reporting assignment split over year end RRS feed

  • Question

  • Hi, first post so hope not a dumb question.

    I am reporting using powerbi / Excel and trying to report on assignment data split over year end. Trouble is I can report using 'assignment start date' or 'assignment end date' but don't know how to get it to recognise if in the middle. 

    eg

    Task Startdate Enddate cost

    Task1  12/12/17 30/12/17 $1000

    Task2 12/12/17 12/2/18 $1000

    Task3 1/1/18 31/1/18 $1000

    if i want to report on tasks in 2018 i can do 'assignment start date > 2018' but only hives me task 3 and ignores task 3

    Don't know if this can be solved (other than getting all project tasks to stop and restart on the year, but this is 1000s task) but any suggestions welcome

    Thanks

    Wednesday, April 11, 2018 1:47 PM

All replies

  • Hi,

    try to use Assignment Finish Date >= 2018 AND Assignment Start Date <= 2018. (Start this year or earliere and finish this year or later)

    Is this what you are looking for?

    Regards
    Barbara

    Wednesday, April 11, 2018 5:10 PM
    Moderator