kakemphaton
New Member
- Joined
- Dec 29, 2012
- Messages
- 5
Hello,
I have an Excel formula. I would like to convert it to a dax formula. But, i have various problems. Always error.
{=SI(SOMME(ESTNUM(CHERCHE(Analyse!$B$2:Analyse!$B$5500;F2))*1)=0;"Not find";INDEX(Analyse!$C$2:Analyse!$C$5500;EQUIV(VRAI;ESTNUM(CHERCHE(Analyse!$B$2:Analyse!$B$5500;F2));0)))}
This formula search words (list of words contains in "analyse") contain in a cell and write a "topic" if a match exist.
Exemple :
Analyse sheet:
a1 : cat
b1 : animal
For this sentence - the cat is in the kitchen, the result is animal.
Thank you !
I have an Excel formula. I would like to convert it to a dax formula. But, i have various problems. Always error.
{=SI(SOMME(ESTNUM(CHERCHE(Analyse!$B$2:Analyse!$B$5500;F2))*1)=0;"Not find";INDEX(Analyse!$C$2:Analyse!$C$5500;EQUIV(VRAI;ESTNUM(CHERCHE(Analyse!$B$2:Analyse!$B$5500;F2));0)))}
This formula search words (list of words contains in "analyse") contain in a cell and write a "topic" if a match exist.
Exemple :
Analyse sheet:
a1 : cat
b1 : animal
For this sentence - the cat is in the kitchen, the result is animal.
Thank you !
