Comparing id's which are falling previous date to current date

[bethamsetty]

Compare perior day to current day using uniue id if the id was on the prior report but not on the current report count it as closed

is there any extra id's added to the current day that should not be counted

[BA_Pete]

Hi @bethamsetty ,

Try a measure something like this:

_closedToday = 
VAR __yesterday =
CALCULATETABLE(
    VALUES(yourTable[yesterday]),
    NOT ISBLANK(yourTable[yesterday])
)
VAR __today =
CALCULATETABLE(
    VALUES(yourTable[today]),
    NOT ISBLANK(yourTable[today])
)
RETURN
COUNTROWS(
    EXCEPT(
        __yesterday,
        __today
    )
)

Pete

[bethamsetty]

Hi Thank you for your help this is not working

[BA_Pete]

What's not working? Is there an error? Are you getting a different value than you expect? What?

Pete