+254 721 331 808    training@upskilldevelopment.com

Home / Monitoring and Evaluation

DAX Formulas for Complex Programme Performance Metrics Training Course

Master advanced DAX formulas to calculate complex programme performance metrics, automate indicator analysis, compare targets with actual results, and build dynamic Power BI dashboards. Strengthen M&E reporting accuracy and turn programme data into actionable management insights.
Duration: 5 Days Classroom & Online In-House Available Certificate on Completion

Training Registration & Schedule

Compare training options, fees and available dates, then register for your preferred session.

Online Training Registration

Training ModePlatformDurationFee per ParticipantRegistration
LIVE ONLINEInstructor-led training Zoom / Google MeetAttend from anywhere 5 days USD 900 Register Online →

Classroom / On-site Training Schedule

15 upcoming sessions

Swipe horizontally to see all columns →

Training DatesLocationTraining ModeFee per ParticipantRegistration
14 Dec 2026 – 18 Dec 20265 training days Nairobi CLASSROOM USD 1,500 Register Now →
14 Dec 2026 – 18 Dec 20265 training days Kigali CLASSROOM USD 2,500 Register Now →
14 Dec 2026 – 18 Dec 20265 training days Dubai CLASSROOM USD 4,900 Register Now →
14 Dec 2026 – 18 Dec 20265 training days Mombasa CLASSROOM USD 1,750 Register Now →
11 Jan 2027 – 15 Jan 20275 training days Nairobi CLASSROOM USD 1,500 Register Now →
08 Feb 2027 – 12 Feb 20275 training days Nairobi CLASSROOM USD 1,500 Register Now →
08 Mar 2027 – 12 Mar 20275 training days Nairobi CLASSROOM USD 1,500 Register Now →
12 Apr 2027 – 16 Apr 20275 training days Nairobi CLASSROOM USD 1,500 Register Now →
10 May 2027 – 14 May 20275 training days Nairobi CLASSROOM USD 1,500 Register Now →
14 Jun 2027 – 18 Jun 20275 training days Nairobi CLASSROOM USD 1,500 Register Now →
12 Jul 2027 – 16 Jul 20275 training days Nairobi CLASSROOM USD 1,500 Register Now →
09 Aug 2027 – 13 Aug 20275 training days Nairobi CLASSROOM USD 1,500 Register Now →
13 Sep 2027 – 17 Sep 20275 training days Nairobi CLASSROOM USD 1,500 Register Now →
11 Oct 2027 – 15 Oct 20275 training days Nairobi CLASSROOM USD 1,500 Register Now →
08 Nov 2027 – 12 Nov 20275 training days Nairobi CLASSROOM USD 1,500 Register Now →
Need registration assistance? Contact training@upskilldevelopment.com for training dates, invoices and invitation letters.

Nairobi, Kenya Classroom/On-site Training Schedule

Course Date Location Fee Enroll
14/12/2026 to 18/12/2026 Nairobi 1,500 USD Register
11/01/2027 to 15/01/2027 Nairobi 1,500 USD Register
08/02/2027 to 12/02/2027 Nairobi 1,500 USD Register
08/03/2027 to 12/03/2027 Nairobi 1,500 USD Register
12/04/2027 to 16/04/2027 Nairobi 1,500 USD Register
10/05/2027 to 14/05/2027 Nairobi 1,500 USD Register
14/06/2027 to 18/06/2027 Nairobi 1,500 USD Register
12/07/2027 to 16/07/2027 Nairobi 1,500 USD Register
09/08/2027 to 13/08/2027 Nairobi 1,500 USD Register
13/09/2027 to 17/09/2027 Nairobi 1,500 USD Register
11/10/2027 to 15/10/2027 Nairobi 1,500 USD Register
08/11/2027 to 12/11/2027 Nairobi 1,500 USD Register
13/12/2027 to 17/12/2027 Nairobi 1,500 USD Register

Mombasa, Kenya Classroom/On-site Training Schedule

Course Date Location Fee Enroll
14/12/2026 to 18/12/2026 Mombasa 1,750 USD Register

Kigali, Rwanda Classroom/On-site Training Schedule

Course Date Location Fee Enroll
14/12/2026 to 18/12/2026 Kigali 2,500 USD Register

Dubai, UAE Classroom/On-site Training Schedule

Course Date Location Fee Enroll
14/12/2026 to 18/12/2026 Dubai 4,900 USD Register

Dar es Salaam, Tanzania Classroom/On-site Training Schedule

Course Date Location Fee Enroll

Kampala, Uganda Classroom/On-site Training Schedule

Course Date Location Fee Enroll

Course Introduction

Monitoring and Evaluation (M&E) professionals increasingly rely on interactive dashboards and analytical models to measure programme performance, assess progress against targets, compare implementation results, and communicate evidence to decision-makers. As monitoring systems generate larger and more complex datasets, basic spreadsheet calculations often become insufficient for measuring performance consistently across projects, locations, reporting periods, beneficiary groups, and implementation partners. This course equips participants with advanced Data Analysis Expressions (DAX) skills to develop reliable, dynamic, and context-sensitive programme performance metrics using Power BI and other supported Microsoft analytical environments.

The course provides a structured understanding of how DAX formulas work within analytical data models and how measures differ from calculated columns and calculated tables. Participants learn to define meaningful performance indicators, establish appropriate relationships between datasets, and create reusable calculations that respond correctly to filters, slicers, reporting periods, geographic categories, and programme dimensions. The training emphasizes practical applications in results-based management, performance monitoring, programme evaluation, and institutional reporting, enabling participants to move beyond static calculations toward flexible analytical models that support recurring management decisions.

A major component of the training focuses on developing complex programme performance metrics. Participants learn to calculate achievement rates, target variance, implementation progress, year-to-date performance, cumulative outputs, completion percentages, beneficiary reach, budget absorption, expenditure efficiency, and other operational indicators. They explore how to handle incomplete reporting periods, changing targets, missing observations, and differences between planned and actual results. The course also examines the importance of defining denominators, aggregation rules, and reporting conventions correctly so that indicators remain meaningful when users examine results across different levels of the programme results framework.

Participants will develop practical competence in DAX filter context, row context, context transition, and evaluation behavior, which are fundamental to understanding why calculations produce different results under different analytical conditions. Through guided exercises, they will apply functions such as CALCULATE, FILTER, ALL, REMOVEFILTERS, VALUES, SUMX, AVERAGEX, DIVIDE, SELECTEDVALUE, and time intelligence functions to solve realistic M&E reporting challenges. These techniques enable the development of dynamic measures, conditional performance classifications, comparative indicators, weighted aggregations, and calculations that remain consistent across interactive dashboards and management reports.

The course integrates data quality, analytical validation, and responsible interpretation into the design of programme performance metrics. Participants learn to test formulas against known results, investigate unexpected totals, manage blank and zero values, identify double-counting risks, and distinguish between additive and non-additive indicators. They also examine how inconsistent reporting frequencies, duplicated records, changing indicator definitions, and poorly designed data relationships can distort performance calculations. By incorporating documentation and validation procedures into their DAX workflows, participants can improve transparency, reproducibility, and confidence in the results presented to programme managers, implementing partners, donors, and evaluation stakeholders.

By the end of the training, participants will be able to design, optimize, and validate advanced DAX measures for complex programme performance analysis. They will gain the skills to build reusable metric libraries, calculate multidimensional performance indicators, compare results against targets and historical baselines, and support interactive reporting across projects and reporting periods. The knowledge gained will strengthen analytical capacity, reduce dependence on repetitive manual calculations, improve the consistency of performance reporting, and help organizations transform monitoring data into timely, actionable evidence for programme adaptation, resource allocation, accountability, and continuous improvement.

Duration

5 days

Who Should Attend

  • Monitoring and Evaluation officers responsible for developing programme performance indicators and analytical reports.

  • M&E managers seeking consistent and dynamic calculations across projects, programmes, and reporting periods.

  • Power BI developers who need to create advanced DAX measures for interactive performance dashboards.

  • Data analysts responsible for calculating achievement rates, target variance, cumulative progress, and operational performance metrics.

  • Results-based management specialists working with results frameworks, logical frameworks, indicator reference sheets, and performance measurement plans.

  • Programme managers who use analytical dashboards to monitor implementation progress and make evidence-based decisions.

  • Monitoring information system officers responsible for integrating datasets and maintaining analytical reporting models.

  • Evaluation specialists comparing baseline, midline, endline, and follow-up performance across programme interventions.

  • Data visualization professionals developing advanced reports for donors, government agencies, and development partners.

  • Public sector performance management officers measuring institutional targets and service delivery results.

  • NGO and development programme personnel consolidating indicator results across implementing partners and geographic locations.

  • Research and information management officers working with multidimensional datasets and recurring performance reports.

  • Financial and programme performance analysts examining budget utilization, expenditure efficiency, and implementation progress.

  • Business intelligence professionals supporting organizational scorecards, strategic performance monitoring, and management reporting.

  • Excel and Power BI users with foundational analytical knowledge who want to advance their DAX formula development skills.

Course Objectives

By the end of this course, participants will be able to:

  • Explain DAX syntax, evaluation behavior, and the differences between measures, calculated columns, and calculated tables in analytical models used for programme performance reporting.

  • Design appropriate analytical data models with fact tables, dimension tables, relationships, and date tables to support accurate and maintainable programme performance calculations.

  • Apply row context, filter context, context transition, and CALCULATE behavior to develop formulas that respond correctly to interactive report filters and analytical dimensions.

  • Develop dynamic DAX measures for achievement rates, target variance, completion percentages, cumulative outputs, beneficiary reach, and other complex programme indicators.

  • Use iterator functions, conditional logic, and context modification functions to calculate weighted averages, conditional totals, distinct beneficiary counts, and multidimensional performance metrics.

  • Implement time-based calculations for year-to-date results, previous-period comparisons, rolling windows, cumulative progress, and historical performance analysis using appropriate date-modeling practices.

  • Construct robust formulas that handle blanks, zeros, missing observations, incomplete periods, changing targets, and other common challenges in programme monitoring datasets.

  • Validate DAX calculations by reconciling measure outputs with source data, checking aggregation behavior, testing filter interactions, and investigating unexpected totals or discrepancies.

  • Optimize DAX measures and analytical models by simplifying expressions, reducing unnecessary calculations, and applying appropriate modeling and performance troubleshooting techniques.

  • Build documented, reusable DAX metric libraries that improve the consistency, transparency, and maintainability of programme dashboards, management scorecards, and performance reports.

Comprehensive Course Outline

Module 1: Foundations of DAX for Programme Performance Measurement

  • Understanding DAX as a formula language for defining calculations in Power BI and other supported Microsoft analytical environments.

  • Distinguishing calculated columns, measures, and calculated tables, including their different roles in programme performance reporting and analytical modeling.

  • Reviewing common M&E indicators such as target achievement, implementation progress, beneficiary coverage, budget utilization, and outcome measurement.

  • Establishing naming conventions, calculation documentation, and metric definitions that support consistent interpretation across reports and organizational teams.

Module 2: Data Modeling for Complex Programme Metrics

  • Designing fact and dimension tables for projects, indicators, locations, reporting periods, beneficiaries, activities, and implementation partners.

  • Creating and validating relationships between datasets while identifying risks associated with ambiguous relationships, many-to-many joins, and duplicate records.

  • Building a dedicated date table with appropriate date attributes to support reliable period comparisons and time intelligence calculations.

  • Designing a scalable semantic model that separates source data, indicator definitions, targets, actual results, and reusable analytical dimensions.

Module 3: DAX Syntax, Context, and Evaluation Principles

  • Applying DAX operators, variables, logical expressions, and core aggregation functions to develop clear and maintainable analytical calculations.

  • Understanding row context and filter context and explaining how they influence calculations across different levels of programme reporting.

  • Using CALCULATE to modify filter context and context transition to control how expressions evaluate within iterators and other calculations.

  • Diagnosing unexpected totals and filter interactions by testing formulas across indicators, projects, reporting periods, and organizational dimensions.

Module 4: Developing Core Programme Performance Indicators

  • Creating measures for actual results, planned targets, target achievement percentages, absolute variance, and percentage deviation from expected performance.

  • Calculating programme completion rates, beneficiary coverage, activity implementation ratios, and indicator progress using consistent numerator and denominator definitions.

  • Applying DIVIDE, IF, SWITCH, and related functions to manage invalid denominators, conditional classifications, missing values, and performance thresholds.

  • Developing dynamic status measures that classify performance into agreed categories while responding correctly to user-selected projects and reporting periods.

Module 5: Advanced Aggregation, Iterators, and Weighted Metrics

  • Applying SUMX, AVERAGEX, COUNTX, and related iterator functions to calculate results that require row-level evaluation before aggregation.

  • Developing weighted averages and composite performance measures using documented weights, approved scoring rules, and appropriate aggregation levels.

  • Calculating distinct beneficiary counts, unique activity totals, and other non-additive measures without introducing double-counting across programme dimensions.

  • Using variables and nested expressions to simplify complex formulas, improve readability, and make calculations easier to validate and maintain.

Module 6: Filter Modification and Multidimensional Analysis

  • Applying CALCULATE, FILTER, ALL, REMOVEFILTERS, ALLEXCEPT, and VALUES to control which records contribute to a performance measure.

  • Creating measures that compare individual project performance with programme-wide results, organizational benchmarks, or selected geographic groupings.

  • Using SELECTEDVALUE and conditional expressions to adapt metric behavior to selected indicators, targets, scenarios, and reporting categories.

  • Building comparative calculations that preserve the intended analytical context while supporting interactive filtering and drill-down across reports.

Module 7: Time Intelligence and Longitudinal Performance Tracking

  • Calculating year-to-date, quarter-to-date, and month-to-date performance for programme indicators with appropriately structured date tables.

  • Developing previous-period, prior-year, and period-over-period comparison measures to identify changes in implementation performance.

  • Creating cumulative progress measures and rolling-period calculations to monitor trends, implementation momentum, and performance over time.

  • Managing incomplete reporting periods, irregular reporting frequencies, missing dates, and changing indicator definitions in longitudinal performance analysis.

Module 8: Complex M&E Metrics, Targets, and Budget Performance

  • Designing measures for cumulative target achievement, milestone completion, output delivery, and outcome progress across multiple programme components.

  • Calculating budget utilization, expenditure-to-output ratios, cost per beneficiary, and related efficiency measures using appropriate financial and operational data.

  • Building weighted programme scorecards and composite indices while documenting the assumptions, thresholds, and aggregation rules behind each metric.

  • Comparing actual performance with baseline values, annual targets, revised targets, and approved benchmarks while maintaining transparent reporting logic.

Module 9: DAX Validation, Troubleshooting, and Performance Optimization

  • Testing measures against source records, independently calculated reference values, and expected results across different reporting dimensions.

  • Diagnosing incorrect totals, unexpected blanks, denominator errors, duplicated counts, relationship issues, and filter-context problems in complex formulas.

  • Using variables, simplified expressions, and efficient modeling practices to improve DAX readability and reduce unnecessary calculation overhead.

  • Documenting metric definitions, formula assumptions, validation evidence, and known limitations to support analytical quality assurance and review.

Module 10: Integrated Programme Performance Dashboard Project

  • Developing an end-to-end DAX metric library using a sample programme dataset containing actual results, targets, reporting dates, and project dimensions.

  • Building and testing dynamic measures for achievement, variance, cumulative progress, beneficiary reach, and comparative programme performance.

  • Integrating validated DAX measures into interactive Power BI visualizations, scorecards, and management reporting pages for different stakeholder needs.

  • Presenting the completed analytical model and documenting its formulas, data dependencies, validation results, interpretation guidance, and opportunities for future improvement.

Training Approach

This course will be delivered by our skilled trainers who have vast knowledge and experience as expert professionals in the fields. The course is taught in English and through a mix of theory, practical activities, group discussion and case studies. Course manuals and additional training materials will be provided to the participants upon completion of the training.

Tailor-Made Course

This course can also be tailor-made to meet organization requirement. For further inquiries, please contact us on: Email: training@upskilldevelopment.com Tel: +254 721 331 808

Training Venue 

The training will be held at our Upskill Training Centre. We also offer training for a group (at a discount of 10% to 50%) at requested location all over the world. The Onsite course fee covers the course tuition, training materials, two break refreshments, buffet lunch, airport transfers, Upskill gift package, and guided tour.

Visa application, travel expenses, dinners, accommodation, insurance, and other personal expenses are catered by the participant

Certification

Participants will be issued with Upskill certificate upon completion of this course.

Airport Pickup and Accommodation

Airport pickup and accommodation is arranged upon request. For booking contact our Training Coordinator through Email: training@upskilldevelopment.com, +254 721 331 808

Terms of Payment:

Unless otherwise agreed between the two parties’ payment of the course fee should be done 3 working days before commencement of the training so as to enable us to prepare better.

Choose Your Training Format

Attend a scheduled session or request a customized programme for your organization.

Classroom Training

Attend instructor-led training at one of our scheduled training locations.

Live Online Training

Join interactive instructor-led sessions remotely from your office or home.

In-House Training

Customize the course content, dates and delivery for your team or organization.

Certification

Participants who successfully complete the programme receive a Certificate of Completion from Upskill Development Institute.

Request Course Information

Need a Tailor-Made Programme?

We can customize the course content, duration, schedule and delivery format to match your organization's objectives.

Dates & Fees Enquire Now

Organizations we've served

Some of Our Recent Clients

We support professional development and institutional capacity building for organizations across a wide range of sectors. Explore a selection of organizations featured in our client portfolio.

SNV logoSNV
National Communications Authority logoNational Communications Authority
Masinde Muliro University of Science and Technology logoMasinde Muliro University of Science and Technology
Kenya Medical Research Institute logoKenya Medical Research Institute
Save Lamu logoSave Lamu
UNICEF logoUNICEF
Fairtrade Africa logoFairtrade Africa
World Agroforestry (ICRAF) logoWorld Agroforestry (ICRAF)
CPI logoCPI
Food and Agriculture Organization (FAO) logoFood and Agriculture Organization (FAO)
University of Southampton logoUniversity of Southampton
Ngali Holdings logoNgali Holdings
STOPAIDS logoSTOPAIDS
International Fertilizer Development Center (IFDC) logoInternational Fertilizer Development Center (IFDC)
Wide Communications logoWide Communications

Learn. Apply. Grow.

Build skills that make a difference at work

Upskill Development Institute offers practical professional training, customized group programmes and flexible learning options to help individuals and organizations strengthen performance.

Chat with us on WhatsApp