Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Report on two different date (Open date and closed date)

Hi

 

I have a dataset with projects and I would like report answering questions like:

 

for projects open in January, in which months did they close?

 

 

ProjectIDOpen DateClose date
aaa01/01/202001/03/2020
aab02/02/202001/03/2020
aac02/01/202002/03/2020

 

Not sure if clear enough. It would be an aggregate, filtering by the projects open in January, the amount of those projects that closed in February, March, April, etc.

 

Thanks,

Need Help

5 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thanks, I saw that one. I forgot to mention that I have them linked to a date table, and I have two measures: one to count the projects open and one to count the project closed. The thing is that I don't know how to show on the same chart the projects open with the count of the closed date. But it has to count the closed projects based on the open project date if it makes sense...

      • amitchandak's avatar
        amitchandak
        Icon for Super User rankSuper User
        6 years ago

        Anonymous , Try like

        Closed project by open date = CALCULATE(COUNT(project[project Id ]), not(isblank(project[close date])) ,USERELATIONSHIP(project[Start Date],'Date'[Date]))