Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi @StevesHelp
Change your & to be && instead.
& will try to concatinate
&& is the logical AND test
Consider using this format too:
Stock or S.O. or DOTCOM = SWITCH( TRUE() , mid(format('omsid sales'[PONUM], "############"), 3,1)="9" && 'OMSID Sales'[shipno]="HD8119", "Stock DOTCOM", MID(FORMAT('OMSID Sales'[ponum], "############"), 3,1)<>"9" && 'OMSID Sales'[shipno]="HD8119", "S.O. DOTCOM", mid(format('omsid sales'[PONUM], "############"), 3,1)="9" && 'OMSID Sales'[shipno]<>"HD8119", "Stock", MID(FORMAT('OMSID Sales'[ponum], "############"), 3,1)<>"9" && 'OMSID Sales'[shipno]<>"HD8119", "S.O.", -- ELSE-- "OTHER")
Hi @StevesHelp
Change your & to be && instead.
& will try to concatinate
&& is the logical AND test
Consider using this format too:
Stock or S.O. or DOTCOM = SWITCH( TRUE() , mid(format('omsid sales'[PONUM], "############"), 3,1)="9" && 'OMSID Sales'[shipno]="HD8119", "Stock DOTCOM", MID(FORMAT('OMSID Sales'[ponum], "############"), 3,1)<>"9" && 'OMSID Sales'[shipno]="HD8119", "S.O. DOTCOM", mid(format('omsid sales'[PONUM], "############"), 3,1)="9" && 'OMSID Sales'[shipno]<>"HD8119", "Stock", MID(FORMAT('OMSID Sales'[ponum], "############"), 3,1)<>"9" && 'OMSID Sales'[shipno]<>"HD8119", "S.O.", -- ELSE-- "OTHER")
User | Count |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |