Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Clustered Chart with 2 different date columns and null values

Need Help!   I have a table with Create Date and Close date with States(Open/Close), am looking for a clustered chart that shows both Open and Closed Tickets by Month.   Created Measure: 1. Open...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    4 years ago

    Hi  Anonymous ,

     

    Try below measures:

    Open Count =
CALCULATE (
    COUNTROWS ( 'Pending Business Review' ),
    FILTER (
        ALL ( 'Pending Business Review' ),
        (
            MONTH ( 'Pending Business Review'[Created Date] )
                = MONTH ( MAX ( 'Dates'[Date] ) )
                || MONTH ( 'Pending Business Review'[PBI Release Date] )
                    = MONTH ( MAX ( 'Dates'[Date] ) )
        )
            && 'Pending Business Review'[State(groups)] = "Open"
    )
)

    Closed Count =
CALCULATE (
    COUNTROWS ( 'Pending Business Review' ),
    FILTER (
        ALL ( 'Pending Business Review' ),
        (
            MONTH ( 'Pending Business Review'[Created Date] )
                = MONTH ( MAX ( 'Dates'[Date] ) )
                || MONTH ( 'Pending Business Review'[PBI Release Date] )
                    = MONTH ( MAX ( 'Dates'[Date] ) )
        )
            && 'Pending Business Review'[State(groups)] = "Closed"
    )
)

    And you will see:

    For the related .pbix file,pls see attached.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my raeply as a solution!

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank you this is working now!

v-kelly-msft's avatar
v-kelly-msft
Community Support
4 years ago

Hi Anonymous ，

 

Glad to help.

 

Best Regards,
Kelly

Did I answer your question? Mark my raeply as a solution!