https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/Keywords/m-p/2044408#M744 <P>Another variation <SPAN>on&nbsp;</SPAN><A href="https://community.powerbi.com/t5/Quick-Measures-Gallery/Text-to-Table/m-p/1312929#M594" target="_blank" rel="noopener">Text to Table - Microsoft Power BI Community</A><SPAN>.&nbsp;This time, extract keywords from text.</SPAN></P> <P>&nbsp;</P> <P>&nbsp;</P> <LI-CODE lang="markup">Keyword = VAR __Separator = " " VAR __SearchText = MAX('Table'[Description]) VAR __Len = LEN(__SearchText) VAR __Count = __Len - LEN(SUBSTITUTE(__SearchText,__Separator,"")) + 1 VAR __Table = SELECTCOLUMNS( ADDCOLUMNS( GENERATESERIES(1,__Count,1), "__Word", VAR __Text = SUBSTITUTE(__SearchText,__Separator,"|",IF([Value]=1,1,[Value]-1)) VAR __Start = SWITCH(TRUE(), __Count = 1,1, [Value] = 1,1, FIND("|",__Text)+1 ) VAR __End = SWITCH(TRUE(), __Count = 1,__Len, [Value] = 1,FIND("|",__Text) - 1, [Value] = __Count,__Len, FIND(__Separator,__Text,__Start)-1 ) VAR __Word = MID(__Text,__Start,__End - __Start + 1) RETURN __Word ), "__Word", [__Word] ) VAR __Keywords = INTERSECT(__Table,SELECTCOLUMNS('Keywords',"__Word",[Key Words])) RETURN CONCATENATEX(__Keywords,[__Word],",")</LI-CODE> <P>&nbsp;</P> <P>&nbsp;</P> <P><SPAN class="reportid hidden">eyJrIjoiNTVlYTBmYjItYzY3ZC00YTgxLWFkZDItZTU4MDczZTM2MmM0IiwidCI6IjRhMDQyNzQzLTM3M2EtNDNkMi04MjdiLTAwM2Y0YzdiYTFlNSIsImMiOjN9</SPAN></P> Sun, 29 Aug 2021 15:31:40 GMT Greg_Deckler 2021-08-29T15:31:40Z https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/Keywords/m-p/2044408#M744 <P>Another variation <SPAN>on&nbsp;</SPAN><A href="https://community.powerbi.com/t5/Quick-Measures-Gallery/Text-to-Table/m-p/1312929#M594" target="_blank" rel="noopener">Text to Table - Microsoft Power BI Community</A><SPAN>.&nbsp;This time, extract keywords from text.</SPAN></P> <P>&nbsp;</P> <P>&nbsp;</P> <LI-CODE lang="markup">Keyword = VAR __Separator = " " VAR __SearchText = MAX('Table'[Description]) VAR __Len = LEN(__SearchText) VAR __Count = __Len - LEN(SUBSTITUTE(__SearchText,__Separator,"")) + 1 VAR __Table = SELECTCOLUMNS( ADDCOLUMNS( GENERATESERIES(1,__Count,1), "__Word", VAR __Text = SUBSTITUTE(__SearchText,__Separator,"|",IF([Value]=1,1,[Value]-1)) VAR __Start = SWITCH(TRUE(), __Count = 1,1, [Value] = 1,1, FIND("|",__Text)+1 ) VAR __End = SWITCH(TRUE(), __Count = 1,__Len, [Value] = 1,FIND("|",__Text) - 1, [Value] = __Count,__Len, FIND(__Separator,__Text,__Start)-1 ) VAR __Word = MID(__Text,__Start,__End - __Start + 1) RETURN __Word ), "__Word", [__Word] ) VAR __Keywords = INTERSECT(__Table,SELECTCOLUMNS('Keywords',"__Word",[Key Words])) RETURN CONCATENATEX(__Keywords,[__Word],",")</LI-CODE> <P>&nbsp;</P> <P>&nbsp;</P> <P><SPAN class="reportid hidden">eyJrIjoiNTVlYTBmYjItYzY3ZC00YTgxLWFkZDItZTU4MDczZTM2MmM0IiwidCI6IjRhMDQyNzQzLTM3M2EtNDNkMi04MjdiLTAwM2Y0YzdiYTFlNSIsImMiOjN9</SPAN></P> Sun, 29 Aug 2021 15:31:40 GMT https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/Keywords/m-p/2044408#M744 Greg_Deckler 2021-08-29T15:31:40Z