Forum Discussion
vividarinda
Helper II
Helper IIFlag true false condition
Hi, I want to set the new column to "flag" if there is a same value in one column with condition unitno : right(unitno,6), then flagging in one of the data. And other unitno still are flagging as...
pls try this
Column = if(MINX(FILTER('Table',RIGHT('Table'[UnitNo ],6)=right(EARLIER('Table'[UnitNo ]),6)&&'Table'[UnitNo ]>EARLIER('Table'[UnitNo ])),'Table'[UnitNo ])<>"" && MAXX(FILTER('Table',RIGHT('Table'[UnitNo ],6)=right(EARLIER('Table'[UnitNo ]),6)&&'Table'[UnitNo ]<EARLIER('Table'[UnitNo ])),'Table'[UnitNo ])="",0,1)pls see the attachment below
ryan_mayu
Super User
Super Userpls try this
Column = if(MINX(FILTER('Table',RIGHT('Table'[UnitNo ],6)=right(EARLIER('Table'[UnitNo ]),6)&&'Table'[UnitNo ]>EARLIER('Table'[UnitNo ])),'Table'[UnitNo ])<>"" && MAXX(FILTER('Table',RIGHT('Table'[UnitNo ],6)=right(EARLIER('Table'[UnitNo ]),6)&&'Table'[UnitNo ]<EARLIER('Table'[UnitNo ])),'Table'[UnitNo ])="",0,1)
pls see the attachment below
vividarindaHelper II
Helper IIHi ryan_mayu ,
Thank you very much for your help very helpful. This worked !!
- ryan_mayu
you are welcome