Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Month by Month Running Total Graph

I've been struggling at this for a while, so I'd really appreciate some help on this.   I'm trying to visualize the progress on the projects in the dataset (will explain this further). Here is the ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ，

    I created a sample pbix file(see attachment) for you, please check whether that is what you want.

    1. Create a date dimension table, no need to create any relationship with your fact table

    2. Create 3 measures as below to get the count of projects with in progress, completed and abandoned status

    Completed = 
CALCULATE (
    DISTINCTCOUNT ( 'Sheet1'[Peoject ID] ),
    FILTER (
        ALLSELECTED ( 'Sheet1' ),
        'Sheet1'[Status] = "Completed"
            && 'Sheet1'[Completion Date] <= SELECTEDVALUE ( 'Date'[Date] )
    )
)
    In progress = 
CALCULATE (
    DISTINCTCOUNT ( 'Sheet1'[Peoject ID] ),
    FILTER (
        'Sheet1',
        ISBLANK ( 'Sheet1'[Completion Date] )
            || 'Sheet1'[Completion Date] >= SELECTEDVALUE ( 'Date'[Date] )
    )
)
    Abandoned = 
CALCULATE (
    DISTINCTCOUNT ( 'Sheet1'[Peoject ID] ),
    FILTER (
        'Sheet1',
        'Sheet1'[Status] = "Abandoned"
            && 'Sheet1'[Completion Date] <= SELECTEDVALUE ( 'Date'[Date] )
    )
)

    Best Regards

Ashish_Mathur's avatar
Ashish_Mathur
Super User
5 years ago

Hi,

You may download my PBI file from here.

Hope this helps.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thank you so much - I reverse engineered what you did in the file to my larger dataset and got it to work after weeks of struggling. Thanks again!