Forum Discussion
MintuBaruah
4 years agoHelper III
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...
- 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.
MintuBaruah
4 years agoHelper III
Hi Icey
Yes, I only want the Flag (True()) for the changed value(ie 200000.).
After making the above changes I am getting this:
Thank you.
Icey
4 years agoCommunity Support
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.
- MintuBaruah4 years agoHelper III