What is Table.FindText in Power Query and How Do We Use It?
Table.FindText is a Power Query function in Power BI that returns the rows in a table that contain specific text. If the text is not found in the table, then an empty table is returned. Syntax Table.FindText has simple syntax and can be written as the below. Table.FindText(table as table, text as text) as table…