How to compare changes by date

Hi deanbland ,

 

 

No Due Date - 1 (I5) While there are two with no due dates, I am just looking to represent a change in this statue. So if an onld Issue changes to not having a due date, I would want to represent this, not the total number without one overall.  

 

---

To my understand, this one is "I3", changed from "31/12/2021" to blank. Right?

 

Then try to create measures like so:

New = 
VAR ThisWeek_ =
    MAX ( 'Table'[Export Date] )
VAR LastWeek_ =
    CALCULATE ( MAX ( 'Table'[Export Date] ), 'Table'[Export Date] < ThisWeek_ )
VAR IssuesThisWeek_ =
    DISTINCT (
        SUMMARIZE (
            FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Export Date] = ThisWeek_ ),
            'Table'[Issue ID]
        )
    )
VAR IssuesLastWeek_ =
    DISTINCT (
        SUMMARIZE (
            FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Export Date] = LastWeek_ ),
            'Table'[Issue ID]
        )
    )
VAR NewIssues_ =
    EXCEPT ( IssuesThisWeek_, IssuesLastWeek_ )
RETURN
    COUNTROWS ( NewIssues_ )

Closed = 
VAR ThisWeek_ =
    MAX ( 'Table'[Export Date] )
VAR LastWeek_ =
    CALCULATE ( MAX ( 'Table'[Export Date] ), 'Table'[Export Date] < ThisWeek_ )
VAR IssuesThisWeek_ =
    DISTINCT (
        SUMMARIZE (
            FILTER (
                ALLSELECTED ( 'Table' ),
                'Table'[Export Date] = ThisWeek_
                    && 'Table'[Status] = "Closed"
            ),
            'Table'[Issue ID]
        )
    )
VAR IssuesLastWeek_ =
    DISTINCT (
        SUMMARIZE (
            FILTER (
                ALLSELECTED ( 'Table' ),
                'Table'[Export Date] = LastWeek_
                    && 'Table'[Status] <> "Closed"
            ),
            'Table'[Issue ID]
        )
    )
VAR ClosedIssues_ =
    INTERSECT ( IssuesThisWeek_, IssuesLastWeek_ )
RETURN
    COUNTROWS ( ClosedIssues_ )

Open = 
VAR ThisWeek_ =
    MAX ( 'Table'[Export Date] )
VAR LastWeek_ =
    CALCULATE ( MAX ( 'Table'[Export Date] ), 'Table'[Export Date] < ThisWeek_ )
VAR IssuesThisWeek_ =
    DISTINCT (
        SUMMARIZE (
            FILTER (
                ALLSELECTED ( 'Table' ),
                'Table'[Export Date] = ThisWeek_
                    && 'Table'[Status] = "Open"
            ),
            'Table'[Issue ID]
        )
    )
VAR IssuesLastWeek_ =
    DISTINCT (
        SUMMARIZE (
            FILTER (
                ALLSELECTED ( 'Table' ),
                'Table'[Export Date] = LastWeek_
                    && 'Table'[Status] <> "Open"
            ),
            'Table'[Issue ID]
        )
    )
VAR OpenIssues_ =
    INTERSECT ( IssuesThisWeek_, IssuesLastWeek_ )
RETURN
    COUNTROWS ( OpenIssues_ ) + [New]

No Due Date = 
VAR ThisWeek_ =
    MAX ( 'Table'[Export Date] )
VAR LastWeek_ =
    CALCULATE ( MAX ( 'Table'[Export Date] ), 'Table'[Export Date] < ThisWeek_ )
VAR IssuesThisWeek_ =
    DISTINCT (
        SUMMARIZE (
            FILTER (
                ALLSELECTED ( 'Table' ),
                'Table'[Export Date] = ThisWeek_
                    && ISBLANK ( 'Table'[Due Date] )
            ),
            'Table'[Issue ID]
        )
    )
VAR IssuesLastWeek_ =
    DISTINCT (
        SUMMARIZE (
            FILTER (
                ALLSELECTED ( 'Table' ),
                'Table'[Export Date] = LastWeek_
                    && NOT ( ISBLANK ( 'Table'[Due Date] ) )
            ),
            'Table'[Issue ID]
        )
    )
VAR NoDueDateIssues_ =
    INTERSECT ( IssuesThisWeek_, IssuesLastWeek_ )
RETURN
    COUNTROWS ( NoDueDateIssues_ )

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.