Skip to Main Content
Learn Power BI
book

Learn Power BI

by Greg Deckler
September 2019
Beginner to intermediate content levelBeginner to intermediate
362 pages
9h 22m
English
Packt Publishing
Content preview from Learn Power BI

Creating measures for utilization

Because measures can exist in any table, it is often considered good practice to place measures in their own table for ease of reference and use.

To create this table, follow these steps:

  1. Select the Home tab in the ribbon. Then, in the External data section, choose Get Data and then Blank Query. This opens the Power Query Editor.
  2. Rename the query #Measures in the Query Settings pane by editing the Name property. Right-click the #Measures query in the Queries pane and uncheck Include in report refresh as there is no reason to refresh a blank query.
  3. From the ribbon, choose Close & Apply. Note that a new table, #Measures, appears at the top of the tables list in the FIELDS pane.
  4. Select Measure in the Hours ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Learn Power BI - Second Edition

Learn Power BI - Second Edition

Greg Deckler

Publisher Resources

ISBN: 9781838644482Supplemental Content