Forum Discussion
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 b...
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
Hi Thank you for your help this is not working
What's not working? Is there an error? Are you getting a different value than you expect? What?
Pete