Power BI / Intermediate: context, quality and access

Power BI β€” Intermediate: context, quality and access

Develop precise DAX context, date, combination, RLS and refresh contracts.

6 lessons Β· No account required

What you will learn

  • Explain CALCULATE as evaluation under modified filter context.
  • Define freshness using data timestamps and quality checks.

  1. CALCULATE and filter modification

    Predict how a measure changes when a calculation replaces, intersects or removes a documented filter.

    Start learning

  2. Iterators, row context and related data

    Explain row-by-row expressions and relationship lookups without assuming a current row automatically filters every table.

    Start learning

  3. Date tables and time comparisons

    Create an explicit calendar contract and interpret cumulative and prior-period measures with date completeness and business-calendar assumptions.

    Start learning

  4. Merge, append, folding and privacy

    Combine prepared tables without multiplying facts, and distinguish source-side transformation from local evaluation and privacy decisions.

    Start learning

  5. Row-level security and access boundaries

    Separate data-row restrictions from report filters, workspace roles and distribution permissions while designing explicit identity-based acceptance cases.

    Start learning

  6. Refresh, gateways and freshness evidence

    Trace source availability, preparation, model refresh and report observations without equating a published file or successful schedule with current data.

    Start learning
Back to course