Professional Development · IT & Digital · Module 8: Power Pivot and DAX

CALCULATE, FILTER, and Context in DAX

4 Abschnitte1 Karteikarten-Decks1 Quizze

Master CALCULATE — the most important DAX function — to evaluate expressions in modified filter contexts; use ALL, ALLEXCEPT, FILTER, and KEEPFILTERS; understand context transition; and build time intelligence measures including YTD, year-over-year, running totals, and percentage contribution.

Inhaltsübersicht

  • Understanding Filter Context in Depth
  • CALCULATE: The Most Important DAX Function
  • FILTER, KEEPFILTERS, and Context Transition
  • Time Intelligence with CALCULATE: YTD, YoY, and Running Totals
coffee, cup, filter, coffee filter, paper filter, brewed coffee, black coffee, caffeine, coffee break, morning coffee, coffee cup, cup of coffee, drink, beverage, aroma, stimulant, tableware, red cup, coffee, coffee, coffee, coffee, coffee
Pixabay – Pixabay License

📚 Vollständiges Lernmaterial mit 4 Abschnitten, Karteikarten und Quizzen verfügbar nach Anmeldung.

Jetzt kostenlos lernen →

Related Topics

Interaktiv lernen mit Karteikarten & Quizzen

Melde dich an und lerne Excel for Professionals — Beginner to Power User mit intelligenten Wiederholungen, Quizzen und KI-Lernhilfen. 7 Tage kostenlos.

Kostenlos testen