Forum Discussion

mattyj2009's avatar
mattyj2009
Icon for Helper II rankHelper II
8 years ago
Solved

Pull data from two rows to compare dates and service identifiers and return true or false

Good Afternoon, I have a report I'm needing to see if a service just moved from one account to another like changing ownership.  So if the connect date and the disconnect date are the same for the...
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    Perhaps something along these lines:

     

    Column = VAR previous = MAXX(FILTER(Services,[Service Identifier]=EARLIER(Services[Service Identifier]) && [Connect Date]=EARLIER([Disconnect Date]) && [Account Number]<>EARLIER(Services[Account Number])),Services[Connect Date]) RETURN IF(ISBLANK(previous),FALSE(),TRUE())
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

Perhaps something along these lines:

 

Column = VAR previous = MAXX(FILTER(Services,[Service Identifier]=EARLIER(Services[Service Identifier]) && [Connect Date]=EARLIER([Disconnect Date]) && [Account Number]<>EARLIER(Services[Account Number])),Services[Connect Date]) RETURN IF(ISBLANK(previous),FALSE(),TRUE())