Forum Discussion

Loic_Pedro_Hans's avatar
Loic_Pedro_Hans
Regular Visitor
3 years ago
Solved

problem with text functions

Hi,   I try to buid a simple formula to extract the first name   My formula is :    Prenom = VAR Pos_Virgule = IFERROR (FIND(",",Customer[Name]), BLANK() ) VAR Taille = LEN( 'Customer...
Need Help
  • Loic_Pedro_Hans's avatar
    Loic_Pedro_Hans
    Regular Visitor
    3 years ago

    Thanks Sakiko !!

    I see my error

     

    Prenom =
    VAR Pos_virgule = IFERROR (FIND(",",Customer[Name]), BLANK() )
    VAR Taille = LEN( 'Customer'[Name])
    VAR Mon_Prenom =
        IF (
            NOT ISBLANK(Pos_Virgule),    
            LEFT( 'Customer'[Name], Taille - Pos_virgule),
            'Customer'[Name]
        )
    Return Mon_Prenom