Forum Discussion

BachFel's avatar
BachFel
Icon for Helper II rankHelper II
8 years ago
Solved

Wildcard and if

Hi,   I have one column where peolpe were able to wirte down a free text. This is my actual formula:   Zeitpunkt der Begehung = IF (     LEFT ( 'LN'[Leistungsbeschreibung]; 14 ) = "Objektbegeh...
Need Help
  • MFelix's avatar
    MFelix
    8 years ago

    Hi BachFel,

     

    Try this formula:

    Zeitpunkt der Begehung =
IF (
    SEARCH ( "Objektbegehung"; 'LN'[Leistungsbeschreibung]; 1; 0 ) > 0;
    LEFT ( 'LN'[Datum]; 10 )
)

     

    Regards,

    MFelix

MFelix's avatar
MFelix
Icon for Super User rankSuper User
8 years ago

Hi BachFel,

 

Try this formula:

Zeitpunkt der Begehung =
IF (
    SEARCH ( "Objektbegehung"; 'LN'[Leistungsbeschreibung]; 1; 0 ) > 0;
    LEFT ( 'LN'[Datum]; 10 )
)

 

Regards,

MFelix

BachFel's avatar
BachFel
Icon for Helper II rankHelper II
8 years ago

It worked, thank you so much!

 

I have another formula where I need to use the search funct. u used, again.

 

Datum der Besichtigung = CALCULATE(MIN('LN'[Zeitpunkt der Begehung]);FILTER(KontElemente;KontElemente[MandantID]=2);FILTER('LN';'LN'[Leistungsbeschreibung]=("Objektbegehung"));FILTER('LN';'LN'[KontElementID]=EARLIER(KontElemente[KontElementID])))

 

Is it possible to install your search function in the formula above.

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    8 years ago

    Hi BachFel,

     

    Can you please explain a little bit better what you want to achieve with the function?

     

    From what I can understand you have a column that as the word "Objektbegehung" in your model or am I  understanding your formula incorrectly?

     

    Regards,

    MFelix