Forum Discussion

markefrody's avatar
markefrody
Icon for Post Patron rankPost Patron
3 years ago
Solved

Setting Up Conditional Column Using Alpha Numeric ID

Hi Sirs, I am trying to create a "Classification" column wherein I try to classify the following alpha numeric: 1.) If ID starts with "MBKX" classify as "Private" 2.) If ID starts with "SMIX" ...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    3 years ago

    markefrody 

    you can try this to create a measure

    Measure = 
 
var _mbkx=IFERROR(find("MBKX",MAX('Table'[ID])),0)
var _smix=IFERROR(find("SMIX",MAX('Table'[ID])),0)
var _sub=len(SUBSTITUTE(MAX('Table'[ID]),"SMIX",""))
return if(_mbkx>0,"Private",if(_smix>0&&_sub>=5,"Private","Public"))

markefrody's avatar
markefrody
Icon for Post Patron rankPost Patron
3 years ago

Hi guys. Any other suggestions? Thanks.