Find

  • 2023-03-22
  • Morten Lønskov
Applies to:
  • ✔ Desktop Edition
  • ✔ Business Edition
  • ✔ Enterprise Edition

In Tabular Editor, you can use the advanced Find functionality to search for specific expressions throughout your open documents and dataset. The Find dialog box is accessible through the keyboard shortcut Ctrl+F.

Find Dialog Box
Figure 1: Find window in Tabular Editor. Ctrl+F opens the dialog box

To perform a search, define the expression you want to search for, and use the Options to determine if certain criteria should be met. For example, you can choose whether the case should match between your find expression and the found text or use regular expressions to search with.

Look in

Additionally, you can specify where to Look in, different areas of your Tabular Editor instance, to limit or expand the scope of your search. The Look in options include:

Find and Replace Dialog Box
Figure 2: Find/Replace window in Tabular Editor. Ctrl+F opens the dialog box
  • Selection: Search within the selection in the current open document (Cannot search through your dataset)
  • Current document: Search through the entire document that you currently have open (Cannot search through your dataset)
  • All open documents: Searches all open documents (Cannot search through your dataset)
  • Entire model: Searches the TOM Explorer for matches in your dataset.
    • Allows for searching within the individual parts of your dataset such as Names, Expressions, Annotations etc.
    • You can also search using Dynamic LINQ in this mode to, for example, find all columns that do not have summarize set to none.
Tip

You can also use the search field in the TOM Explorer to search your dataset instead of the Find dialog

Replace

The Replace dialog allows you in the same way as Find to search for an expression and then replace it with a different expression.

The Replace dialog does not require anything in the Replace with field, but leaving it empty will replace your searched for expression with an empty expression. You have the same options as in the Find dialog to determine search criteria, but the Look in functionality is only for documents, i.e. you cannot search and replace within your dataset objects.

Replace Dialog Box
Figure 3: Replace window in Tabular Editor. Ctrl+F opens the dialog box
Tip

If you are trying to rename variables in a DAX statement (Expression or Script), Ctrl+R will let you refactor a selected variable