{"id":10428,"date":"2025-06-24T13:59:17","date_gmt":"2025-06-24T12:59:17","guid":{"rendered":"https:\/\/republify.se\/?post_type=product&p=10428"},"modified":"2026-01-08T18:46:20","modified_gmt":"2026-01-08T17:46:20","slug":"introduction-to-dax","status":"publish","type":"product","link":"https:\/\/republify.se\/index.php\/produkt\/introduction-to-dax\/","title":{"rendered":"Introduction to DAX"},"content":{"rendered":"

Module 1: Introduction to DAX<\/strong>
\n\u2022 Purpose of DAX in Power BI, Power Pivot, and SSAS Tabular models.
\n\u2022 Basic syntax and formula structure (functions, operators, expressions).
\n\u2022 Calculated columns vs. measures vs. calculated tables.
\n\u2022 Introduction to data types and type handling in DAX.
\n\u2022 Importance of data model in DAX logic.<\/p>\n

Module 2: DAX Row Context<\/strong>
\n\u2022 Definition of row context and when it applies.
\n\u2022 How row context is created in calculated columns.
\n\u2022 Iterators (e.g., SUMX, FILTER, AVERAGEX) and their relation to row context.
\n\u2022 Common pitfalls (e.g., why SUM(Table[Column]) behaves differently from
\nSUMX).
\n\u2022 Row context in nested functions.<\/p>\n

Module 3: DAX Query and Filter Context<\/strong>
\n\u2022 Understanding filter context in measures.
\n\u2022 How filter context is created by visuals, slicers, and filters.
\n\u2022 Interaction of row context and filter context.
\n\u2022 Use of CALCULATE to modify filter context.
\n\u2022 Examples showing context transition from row to filter context.<\/p>\n

Module 4: DAX in PBIDT (Power BI Desktop Tool)<\/strong>
\n\u2022 Writing and debugging DAX in Power BI Desktop.
\n\u2022 Formula bar, measure pane, and table tools.
\n\u2022 Using Quick Measures and tooltips for guidance.
\n\u2022 Exploring performance analyzer for DAX tuning.
\n\u2022 Preview of external tools like DAX Studio and Tabular Editor.<\/p>\n

Module 5: Introducing Evaluation Context<\/strong>
\n\u2022 Combining row and filter contexts under the term evaluation context.
\n\u2022 Context transition explained with examples (CALCULATE, row context to
\nfilter context).
\n\u2022 How context affects measure results in different visuals.
\n\u2022 Examples using nested iterators and CALCULATE to illustrate context
\nevaluation.<\/p>\n

Module 6: Introducing CALCULATE<\/strong>
\n\u2022 CALCULATE as the gateway to context transition.
\n\u2022 Basic syntax and usage patterns.
\n\u2022 Adding, modifying, and removing filters within CALCULATE.
\n\u2022 Use with ALL, FILTER, VALUES, REMOVEFILTERS.
\n\u2022 Troubleshooting common CALCULATE issues.<\/p>\n

Module 7: DAX Time Intelligence<\/strong>
\n\u2022 Built-in time intelligence functions: DATESYTD, SAMEPERIODLASTYEAR,
\nDATEADD, etc.
\n\u2022 Pre-requisites: date table and marked as a Date Table.
\n\u2022 Handling YTD, QTD, MTD, rolling averages.
\n\u2022 Custom time intelligence with CALCULATE, FILTER, DATESBETWEEN.
\n\u2022 Common mistakes (non-contiguous dates, missing data).<\/p>\n

Module 8: DAX Calculation Groups<\/strong>
\n\u2022 Introduction to calculation groups in Tabular Editor.
\n\u2022 Creating dynamic measures (e.g., YTD, QoQ, % of total).
\n\u2022 Syntax using SELECTEDMEASURE() and ISSELECTEDMEASURE().
\n\u2022 Managing format strings and precedence.
\n\u2022 Best practices to reduce measure explosion.<\/p>\n

Module 9: Querying DAX<\/strong>
\n\u2022 DAX as a query language (not just calculated expressions).
\n\u2022 Writing EVALUATE statements.
\n\u2022 Using DEFINE MEASURE, VAR, and RETURN.
\n\u2022 Querying tables with filters, columns, and summarizations.
\n\u2022 Using DAX Studio for query testing and optimization.<\/p>\n

 <\/p>\n

 <\/p>\n

Kursen levereras i samarbete med<\/h3>\n

\"\"<\/p>\n

<\/h2>\n","protected":false},"excerpt":{"rendered":"

Vill du ta dina Power BI-modeller till n\u00e4sta niv\u00e5? Den h\u00e4r utbildningen ger dig en djupg\u00e5ende f\u00f6rst\u00e5else f\u00f6r DAX \u2013 spr\u00e5ket som g\u00f6r det m\u00f6jligt att skapa kraftfulla ber\u00e4kningar, flexibla m\u00e5tt och smarta datamodeller. <\/strong><\/p>\n

Genom tydliga moduler, praktiska exempel och f\u00f6rklaringar av begrepp som kontext\u00f6verg\u00e5ng, CALCULATE och Time Intelligence f\u00e5r du verktygen att analysera data p\u00e5 riktigt.<\/p>\n","protected":false},"featured_media":2818,"comment_status":"open","ping_status":"closed","template":"","meta":{"wds_primary_product_brand":0,"wds_primary_product_cat":0},"product_brand":[],"product_cat":[30,90,54],"product_tag":[],"class_list":{"0":"post-10428","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-business","7":"product_cat-business-intelligence","8":"product_cat-powerbi","10":"first","11":"instock","12":"taxable","13":"shipping-taxable","14":"purchasable","15":"product-type-simple"},"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/republify.se\/index.php\/wp-json\/wp\/v2\/product\/10428","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/republify.se\/index.php\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/republify.se\/index.php\/wp-json\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"https:\/\/republify.se\/index.php\/wp-json\/wp\/v2\/comments?post=10428"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/republify.se\/index.php\/wp-json\/wp\/v2\/media\/2818"}],"wp:attachment":[{"href":"https:\/\/republify.se\/index.php\/wp-json\/wp\/v2\/media?parent=10428"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/republify.se\/index.php\/wp-json\/wp\/v2\/product_brand?post=10428"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/republify.se\/index.php\/wp-json\/wp\/v2\/product_cat?post=10428"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/republify.se\/index.php\/wp-json\/wp\/v2\/product_tag?post=10428"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}