Prerequisites

This session is an optional add-on to “Power Bi – Design a report from scratch” for those who need to improve their reports with more advanced DAX and features.

Programme

• Review best practices with Power BI.
• Produce a calendar table in M language.
• Normalize your data.
• Work with multiple date fields and deal with inactive relationships: USERELATIONSHIP.
• Further your DAX knowledge:
  • Obtain a ranking: RANKX.
  • Deal with blanks: ISBLANK.
  • Obtain top rankings: ADDCOLUMNS, SUMMARIZE, TOPN.
• Make your report more user-friendly:
  • Create “master-detail” reports using extraction filters.
  • Prepare dynamic comments and titles.
  • Customize tooltips.
  • Use parameters to toggle between measures on a report page.

Advanced – 1 Day

580€ face-to-face

530€ remotely

Prices are without Tax.

Get in touch with us to schedule this Power BI course or for a quote if you are interested in organizing this training within your company.