I have a table as defined below. The DAX column is the column I am trying to create.
I want to have the DAX column flag each row with a yes or no.
Conditions for a yes
Person was at a location on Oct 1, 2018 (last day of the quarter)
Person was at the same location any other date previous in 2018
Condition for no
Person was at a different location on Oct 1, 2018 than the location specified on the date (ex: Jane was at location B on Oct 1, and therefore gets flagged yes on location B but not A for every other date)
Person was not any any location on Oct 1, 2018 (ex: Mike has only 1 date that is not Oct 1).
How would I write the DAX for this flag? I've tried to think of a way to do it with a nested IF but I can't seem to figure it out. Thanks.