Forum Discussion

bethamsetty's avatar
bethamsetty
New Member
3 years ago

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

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

Need Help
Tips and Tricks

3 Replies

  • BA_Pete's avatar
    BA_Pete
    Super User
    3 years ago

    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

      • BA_Pete's avatar
        BA_Pete
        Super User
        3 years ago

         

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

         

        Pete