Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Count of Active Projects between two dates

My apologies if this exists already, i have been searching and found similar, but nothing that has worked when tested out, nor seems to fit this need.   I have a table with a Project ID, Start Date...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

Share some data that i can work with.  I should be able to paste that data in an Excel file.  If possible, please also show the expected result.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Its a simple table, Project list with Start and finish dates.  Two Finish dates remain open because those projects are still active.  

     

    ProjectStart DateFinish Date
    Project 11/1/20185/7/2018
    Project 22/8/2018 
    Project 35/5/20188/20/2018
    Project 48/23/20188/24/2018
    Project 56/5/2018 
    Project 67/2/20188/10/2018
    Project 77/4/20188/9/2018

     

    As i'm new to this, Its hard for me to show what the intended result should be visually...  using a date slicer (slider) i would like to be able to change the dates, and have a card visual show the count of projects that were Active between the dates of the Slider. So if the dates of the Slicer are 8/20/18 and 8/23/18, it should show a count of "4".

     

    Hope this helps illustrate better

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      8 years ago

      Hi,

       

      You may download my PBI file from here.

       

      Hope this helps.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        This is great, thank you both for the help.  however, the real data table I am using is Thousands of lines long.  A crossjoin table to have each possible date the project is open is not feasible due to size and performance concerns.