Microsoft Power BI Cookbook
上QQ阅读APP看书,第一时间看更新

Rename columns

  1. Use the Table.RenameColumns() to apply intuitive names for users and to benefit the Q & A engine for natural language queries.
Figure 69: Column Aliases Applied
  1. Use renaming to remove any source system indicators, add a space between words for non-key columns, and apply dimension-specific names such as Customer Gender rather than Gender.
  2. Key columns will be hidden from the Report View.
  3. Table.RenameColumns() also offers the MissingField.UseNull option.