Find
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.
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:
- 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.
Tip
If you are trying to rename variables in a DAX statement (Expression or Script), Ctrl+R will let you refactor a selected variable