Duration: 1 day (6.5 hours)

Cost: £365 +VAT per person (prices vary for bespoke courses – please enquire)

This course is aimed at existing users who want to expand their skills to use advanced reporting techniques and use DAX to create calculated columns and measures.

Participants should have either attended our Power BI – Introduction course or have equivalent knowledge. You should be able to import and transform data and create simple reports.

By the end of the course you will be able to:

  • Import and connect data tables
  • Create and use date calendars
  • Create calculated columns
  • Create and use measures
  • Use drill down and drill through
  • Create Tooltip pages
  • Add and customise slicers
  • Add action buttons
  • Streamline your report for use in the Power BI Service

  • Importing data
  • Transforming data
  • Adding custom columns
  • Creating data models
  • Building visuals

  • Building date tables
  • Creating Financial Year information
  • Including Month and Day information

  • Power Query custom columns vs DAX columns
  • Creating DAX calculated columns

  • Implicit vs Explicit Measures
  • Building measures
  • Using DAX
  • Common DAX functions

  • Review of drill down
  • Creating drill through pages
  • Using drill through

  • Adding pages to use for Tooltips
  • Linking ToolTip pages to visuals

  • Adding images
  • Adding buttons
  • Setting actions

  • Adding slicers
  • Changing slicer settings
  • Syncing slicers between pages
  • Showing what has been sliced
  • Setting slicer interactions

  • Hiding the navigation bar
  • Stopping users manually filtering

Cost: £365 +VAT per person (prices vary for bespoke courses – please enquire)

Click here to view next available dates and complete booking request.

Please email training@underscore-group.com if you would like to discuss the course before booking or to discuss bespoke programme options.



Back to all courses