Forum Discussion

Helper II

2 years ago

Solved

Flag 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...

2 years ago

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

Flag true false condition.pbix18 KB

ryan_mayu

Super User

2 years ago

vividarinda

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

Flag true false condition.pbix18 KB

vividarinda

Helper II

2 years ago

Hi ryan_mayu ,

Thank you very much for your help very helpful. This worked !!