Forum Discussion

OKgo's avatar
OKgo
Icon for Helper IV rankHelper IV
8 years ago
Solved

DAX help with LEN & SUBSTITUTE

I have a formula that works great in Excel, IF([@[Assigned]]="","",(LEN([@[Assigned]])-LEN(SUBSTITUTE([@[Assigned]],"ASSIGNED","")))/8"))   Example entry from Table[Assigned]: ASSIGNED_Material I...
Need Help
  • ChrisMendoza's avatar
    ChrisMendoza
    8 years ago

    OKgo,

     

    Try:

    Column =
IF (
    'Table'[Assigned] = BLANK (),
    BLANK (),
    DIVIDE (
        LEN ( 'Table'[Assigned] )
            - LEN ( SUBSTITUTE ( 'Table'[Assigned], "ASSIGNED", BLANK () ) ),
        8
    )
)
OKgo's avatar
OKgo
Icon for Helper IV rankHelper IV
8 years ago

In early construction of the Dax formula this error popped up from time to time but then dissappeared.
Calculation error in column 'Table[Assigned]" xxxx of type text to type number