Forum Discussion

MintuBaruah's avatar
MintuBaruah
Helper III
4 years ago
Solved

Pattern in table

Hi @all   Narrative   Ref.   Date   Post Date   Debit Global   SALARY   4/24/2021   2/24/2021   200000.00 HLDGS   NONREF   4/18/2021   3/16/2021     HLDGS   NO...
  • Icey's avatar
    Icey
    4 years ago

    Hi MintuBaruah ,

     

    Something like so?

    Column = 
    VAR PreviousDate_ =
        CALCULATE (
            MAX ( 'Table'[Date] ),
            FILTER (
                'Table',
                'Table'[Narrative] = EARLIER ( 'Table'[Narrative] )
                    && 'Table'[Ref.] = EARLIER ( 'Table'[Ref.] )
                    && 'Table'[Date] < EARLIER ( 'Table'[Date] )
            )
        )
    VAR PreviousDebit_ =
        CALCULATE (
            MAX ( 'Table'[Debit] ),
            FILTER (
                'Table',
                'Table'[Narrative] = EARLIER ( 'Table'[Narrative] )
                    && 'Table'[Ref.] = EARLIER ( 'Table'[Ref.] )
                    && 'Table'[Date] = PreviousDate_
            )
        )
    RETURN
        IF (
            'Table'[Debit] <> BLANK ()
                && PreviousDebit_ <> BLANK (),
            IF ( 'Table'[Debit] <> PreviousDebit_, "True" )
        )
    

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.