Forum Discussion
Trend Analysis
Hi Guys, Asking the community for help, I've a coloumn which has inconsitent data however it has keywords which i'll be using in the "cards" for visualization such as "ABC" and "XYZ". So when I c...
HI
Perhaps, this could help you
srting_carac = SWITCH(TRUE(), CONTAINSSTRING(Feuil1[Column1],"ABC"),"ABC", CONTAINSSTRING(Feuil1[Column1],"XYZ"),"XYZ",CONTAINSSTRING(Feuil1[Column1],"*"),"Other")