Flag true false condition

[vividarinda]

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 1

Example:

UnitNo           | Flag

16DT0789      | 0

77DT0789      | 1

16DT9160      | 1

16DT9254      | 1

77DT0541      | 1

16DT0541      | 0

77DT9167      | 1

77DT7643      | 1

16DT9206     | 1

[zenisekd]

I would follow this post: https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cumulative-RANKX-index-COUNT-OCCURAN... only adjusting it by the right 6 function 🙂 can be done either in Power Query or Dax... 

[ryan_mayu · Accepted solution]

@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

[vividarinda]

Hi @ryan_mayu ,

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

[ryan_mayu]

you are welcome