Forum Discussion

MintuBaruah's avatar
MintuBaruah
Helper III
4 years ago
Solved

Find similar pattern

Hi ALL,   Narrative   Credit   Post date TANZANIA LIMITED   580.00   12/14/2020 TANZANIA LIMITED   580.00   12/14/2020 TANZANIA LIMITED   580.00   12/14/2020 TANZANIA...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    MintuBaruah , A new column like

     


    var _count = countx(filter(Table, [Narrative] =earlier([Narrative]) && [Credi] = earlier([Credi])), [Credi])
    return
    if(_count+0 >=5, True(), false())

amitchandak's avatar
amitchandak
Super User
4 years ago

MintuBaruah , A new column like

 


var _count = countx(filter(Table, [Narrative] =earlier([Narrative]) && [Credi] = earlier([Credi])), [Credi])
return
if(_count+0 >=5, True(), false())