{"id":20405,"date":"2025-03-17T09:22:06","date_gmt":"2025-03-17T09:22:06","guid":{"rendered":"https:\/\/www.pickl.ai\/blog\/?p=20405"},"modified":"2025-03-17T09:22:07","modified_gmt":"2025-03-17T09:22:07","slug":"power-bi-dax","status":"publish","type":"post","link":"https:\/\/www.pickl.ai\/blog\/power-bi-dax\/","title":{"rendered":"Power BI DAX Tutorial for Beginners"},"content":{"rendered":"\n<p><strong>Summary: <\/strong>This Power BI DAX tutorial introduces beginners to the fundamentals of Data Analysis Expressions, including syntax, functions, and context. It covers creating measures and calculated columns, using aggregate functions, and applying time intelligence for advanced Data Analysis.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.pickl.ai\/blog\/power-bi-dax\/#Introduction\" >Introduction<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.pickl.ai\/blog\/power-bi-dax\/#What_is_DAX\" >What is DAX?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.pickl.ai\/blog\/power-bi-dax\/#Why_Learn_DAX\" >Why Learn DAX?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.pickl.ai\/blog\/power-bi-dax\/#Basic_DAX_Concepts\" >Basic DAX Concepts<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.pickl.ai\/blog\/power-bi-dax\/#Syntax\" >Syntax<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.pickl.ai\/blog\/power-bi-dax\/#Functions\" >Functions<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.pickl.ai\/blog\/power-bi-dax\/#Context\" >Context<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.pickl.ai\/blog\/power-bi-dax\/#Measures_and_Calculated_Columns\" >Measures and Calculated Columns<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.pickl.ai\/blog\/power-bi-dax\/#Example_Using_DAX_Functions\" >Example: Using DAX Functions<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.pickl.ai\/blog\/power-bi-dax\/#Example_1_Creating_a_Simple_Measure_in_Power_BI_Using_DAX\" >Example 1: Creating a Simple Measure in Power BI Using DAX<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/www.pickl.ai\/blog\/power-bi-dax\/#Example_Use_Case\" >Example Use Case<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/www.pickl.ai\/blog\/power-bi-dax\/#Tips_for_Beginners\" >Tips for Beginners<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/www.pickl.ai\/blog\/power-bi-dax\/#Example_2_Using_Aggregate_Functions_in_DAX\" >Example 2: Using Aggregate Functions in DAX<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/www.pickl.ai\/blog\/power-bi-dax\/#SUM_Function\" >SUM Function<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/www.pickl.ai\/blog\/power-bi-dax\/#AVERAGE_Function\" >AVERAGE Function<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/www.pickl.ai\/blog\/power-bi-dax\/#COUNT_Function\" >COUNT Function<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/www.pickl.ai\/blog\/power-bi-dax\/#MAX_and_MIN_Functions\" >MAX and MIN Functions<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/www.pickl.ai\/blog\/power-bi-dax\/#DISTINCTCOUNT_Function\" >DISTINCTCOUNT Function<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/www.pickl.ai\/blog\/power-bi-dax\/#Practical_Use_Case\" >Practical Use Case<\/a><\/li><\/ul><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-20\" href=\"https:\/\/www.pickl.ai\/blog\/power-bi-dax\/#Advanced_DAX_Concepts\" >Advanced DAX Concepts<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-21\" href=\"https:\/\/www.pickl.ai\/blog\/power-bi-dax\/#Iterator_Functions\" >Iterator Functions<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-22\" href=\"https:\/\/www.pickl.ai\/blog\/power-bi-dax\/#CALCULATE_Statement_with_Modifiers\" >CALCULATE Statement with Modifiers<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-23\" href=\"https:\/\/www.pickl.ai\/blog\/power-bi-dax\/#Time_Intelligence_Functions\" >Time Intelligence Functions<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-24\" href=\"https:\/\/www.pickl.ai\/blog\/power-bi-dax\/#Calculated_Tables\" >Calculated Tables<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-25\" href=\"https:\/\/www.pickl.ai\/blog\/power-bi-dax\/#Relationship_Functions\" >Relationship Functions<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-26\" href=\"https:\/\/www.pickl.ai\/blog\/power-bi-dax\/#Conclusion\" >Conclusion<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-27\" href=\"https:\/\/www.pickl.ai\/blog\/power-bi-dax\/#Frequently_Asked_Questions\" >Frequently Asked Questions<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-28\" href=\"https:\/\/www.pickl.ai\/blog\/power-bi-dax\/#What_Is_DAX_Used_for_In_Power_BI\" >What Is DAX Used for In Power BI?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-29\" href=\"https:\/\/www.pickl.ai\/blog\/power-bi-dax\/#How_Does_DAX_Differ_from_Excel_Formulas\" >How Does DAX Differ from Excel Formulas?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-30\" href=\"https:\/\/www.pickl.ai\/blog\/power-bi-dax\/#What_are_the_Benefits_of_Learning_DAX\" >What are the Benefits of Learning DAX?<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 id=\"introduction\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Introduction\"><\/span><strong>Introduction<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>In the world of <a href=\"https:\/\/pickl.ai\/blog\/benefits-of-business-intelligence\/\">Business Intelligence<\/a>, <strong>Power BI<\/strong> is a leading tool for Data Analysis and visualization. At the heart of Power BI&#8217;s analytical capabilities is <strong>DAX (Data Analysis Expressions)<\/strong>, a powerful formula language that allows users to create custom calculations and measures. This tutorial is designed for beginners, providing a comprehensive introduction to DAX and its applications in Power BI.<\/p>\n\n\n\n<h2 id=\"what-is-dax\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"What_is_DAX\"><\/span><strong>What is DAX?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>DAX is a collection of functions, operators, and constants used in formulas to calculate and return values. It is essential for creating new insights from existing data models in Power BI. If you have experience with Excel formulas, you will find DAX familiar and intuitive.<\/p>\n\n\n\n<p><strong>Key Takeaways<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Master DAX Basics for Enhanced Analysis<\/li>\n\n\n\n<li>Use DAX to Create Custom Calculations and Measures<\/li>\n\n\n\n<li>Apply Aggregate Functions for Data Summarization<\/li>\n\n\n\n<li>Leverage Time Intelligence for Dynamic Insights<\/li>\n\n\n\n<li>Enhance Reports with Advanced DAX Calculations<\/li>\n<\/ul>\n\n\n\n<h2 id=\"why-learn-dax\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Why_Learn_DAX\"><\/span><strong>Why Learn DAX?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Learning DAX is crucial for unlocking the full potential of <a href=\"https:\/\/pickl.ai\/blog\/capabilities-of-power-bi\/\">Power BI<\/a>. It enables you to perform complex Data Analysis tasks, such as calculating growth percentages across different categories or analysing year-over-year trends. DAX formulas help solve real-world business problems by providing actionable insights from your data.<\/p>\n\n\n\n<h2 id=\"basic-dax-concepts\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Basic_DAX_Concepts\"><\/span><strong>Basic DAX Concepts<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>In the world of <a href=\"https:\/\/pickl.ai\/blog\/power-bi-dashboard-examples\/\">Business Intelligence<\/a>, <strong>DAX (Data Analysis Expressions)<\/strong> is a powerful formula language used in Power BI to create custom calculations and measures. Understanding the basic concepts of DAX is essential for unlocking its full potential. Here are the fundamental elements you need to grasp:<\/p>\n\n\n\n<h3 id=\"syntax\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Syntax\"><\/span><strong>Syntax<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>DAX syntax refers to the structure and elements used in writing formulas. It includes functions, operators, and constants that are combined to perform calculations. Familiarity with <a href=\"https:\/\/pickl.ai\/blog\/features-of-microsoft-excel\/\">Excel<\/a> formulas can help, but DAX syntax is unique in its application to <a href=\"https:\/\/pickl.ai\/blog\/what-is-data-modeling-definition-importance-and-types\/\">data model<\/a>.<\/p>\n\n\n\n<h3 id=\"functions\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Functions\"><\/span><strong>Functions<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>These are predefined formulas that perform specific calculations using arguments. They are categorized into various types, such as:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Date and Time Functions:<\/strong> Useful for time-based analysis, e.g., YEAR, MONTH, DATE.<\/li>\n\n\n\n<li><strong>Time Intelligence Functions:<\/strong> Allow dynamic calculations over time, e.g., SAMEPERIODLASTYEAR.<\/li>\n\n\n\n<li><strong>Logical Functions:<\/strong> Used for conditional logic, e.g., IF, AND, OR.<\/li>\n\n\n\n<li><strong>Aggregate Functions:<\/strong> For summing, averaging, or counting data, e.g., SUM, AVERAGE, COUNT.<\/li>\n<\/ul>\n\n\n\n<h3 id=\"context\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Context\"><\/span><strong>Context<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Context in DAX refers to the current row or filter being evaluated. Understanding context is crucial for creating effective measures and calculated columns. The CALCULATE function is used to modify the context in which a calculation is performed.<\/p>\n\n\n\n<h3 id=\"measures-and-calculated-columns\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Measures_and_Calculated_Columns\"><\/span><strong>Measures and Calculated Columns<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Measures:<\/strong> These are calculations that run across your data model, useful for aggregating values like sums or averages.<\/li>\n\n\n\n<li><strong>Calculated Columns:<\/strong> New columns added to your data model based on DAX formulas, useful for deriving new data points from existing ones.<\/li>\n<\/ul>\n\n\n\n<h2 id=\"example-using-dax-functions\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Example_Using_DAX_Functions\"><\/span><strong>Example: Using DAX Functions<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Let&#8217;s create a measure to calculate the total sales for a specific region using the CALCULATE function:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXfXCc_BJ8z3OeVjU7o63KDbRX8mAmOq1x5O8JERF9uTisvdgruqMsPmj78u9_-Dixp65A7HzvFa18M9KonpgwczOu_Nd5Gr_nFRO9nFdSfgr5YddI4YQqfRBIPQSAzmh1rCySM9cQ?key=3E7EoAGK4ZfgxsXYM8_Gyo4c\" alt=\"the code to use the CALCULATE function\"\/><\/figure>\n\n\n\n<p>This formula filters the sales data to only include transactions from the North region.<\/p>\n\n\n\n<h3 id=\"example-1-creating-a-simple-measure-in-power-bi-using-dax\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Example_1_Creating_a_Simple_Measure_in_Power_BI_Using_DAX\"><\/span><strong>Example 1: Creating a Simple Measure in Power BI Using DAX<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Creating a simple measure in Power BI using DAX is a fundamental step in <a href=\"https:\/\/pickl.ai\/blog\/difference-between-data-analysis-and-interpretation\/\">Data Analysis<\/a>. Measures are calculations that run across your data model, allowing you to sum values, count rows, or perform more complex calculations. Here&#8217;s how to create a measure to calculate the total sales from a dataset.<\/p>\n\n\n\n<p><strong>Step-by-Step Guide<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Open Power BI Desktop<\/strong> and load your data. Ensure that your dataset includes a table with a column for sales amounts.<\/li>\n\n\n\n<li><strong>Go to the Modeling Tab<\/strong> in Power BI. This tab provides tools for creating and managing measures and calculated columns.<\/li>\n\n\n\n<li><strong>Click on &#8220;New Measure.&#8221;<\/strong> This will open a formula bar where you can enter your DAX formula.<\/li>\n\n\n\n<li><strong>Enter the DAX Formula:<\/strong><\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXduu0xvtNtkn-THFMQCFQcoYzYKWDcwCJULLi0RO7t3csAvcK7lvaMSuhVtPo6Mv12uP0NUxjcKiBmd5cli6N8_cSucZEpHMPsShQ8MFyXbLnmkWsktN65TnQs3y0cK3rLRp6JvYg?key=3E7EoAGK4ZfgxsXYM8_Gyo4c\" alt=\"\"\/><\/figure>\n\n\n\n<ol class=\"wp-block-list\">\n<li>This formula uses the SUM function to add up all the values in the &#8220;Amount&#8221; column of your &#8220;Sales&#8221; table.<\/li>\n\n\n\n<li><strong>Name Your Measure:<\/strong> In the formula bar, you can name your measure. For example, you might name it &#8220;Total Sales.&#8221;<\/li>\n\n\n\n<li><strong>Click Enter<\/strong> to apply the formula. Your new measure will now be available in the Fields pane under the table where you created it.<\/li>\n<\/ol>\n\n\n\n<p><strong>Explanation of the Formula<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>SUM Function:<\/strong> This is an aggregate function used to calculate the total of a column.<\/li>\n\n\n\n<li><strong>Sales[Amount]:<\/strong> This refers to the &#8220;Amount&#8221; column in your &#8220;Sales&#8221; table. The syntax Table[Column] is used to specify the column you want to sum.<\/li>\n<\/ul>\n\n\n\n<h3 id=\"example-use-case\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Example_Use_Case\"><\/span><strong>Example Use Case<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Suppose you have a dataset with the following sales amounts:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXc0i06RDl476teZfJU3RgFU9sBZAXQp7Mo3BeLBL1Ww2etJiht-EzbFhsrJ9w4rpwMLfvT5w9O68Op_SCTDx4HufITuJJcXe3kdD3xPOYR2fBno2D3yw5gaL0diWF_D5VW9Q7KJ?key=3E7EoAGK4ZfgxsXYM8_Gyo4c\" alt=\"the dataset of sales amount\"\/><\/figure>\n\n\n\n<p>Using the formula Total Sales = SUM(Sales[Amount]), the result would be:<\/p>\n\n\n\n<p>Total Sales=100+200+300+400=1000Total Sales=100+200+300+400=1000<\/p>\n\n\n\n<h4 id=\"tips-for-beginners\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Tips_for_Beginners\"><\/span><strong>Tips for Beginners<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Use the AutoComplete Feature:<\/strong> As you type in the formula bar, Power BI will suggest functions and column names, helping you avoid typos.<\/li>\n\n\n\n<li><strong>Test Your Measures:<\/strong> After creating a measure, use it in a table or chart to ensure it&#8217;s working as expected.<\/li>\n<\/ul>\n\n\n\n<h3 id=\"example-2-using-aggregate-functions-in-dax\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Example_2_Using_Aggregate_Functions_in_DAX\"><\/span><strong>Example 2: Using Aggregate Functions in DAX<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Aggregate functions in DAX are powerful tools for summarising and <a href=\"https:\/\/pickl.ai\/blog\/different-types-of-data-analysis\/\">analysing data<\/a> in Power BI. These functions allow you to perform calculations such as summing, averaging, counting, and finding maximum or minimum values across your dataset. Here&#8217;s how to use some of the most common aggregate functions in DAX:<\/p>\n\n\n\n<h4 id=\"sum-function\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"SUM_Function\"><\/span><strong>SUM Function<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>The SUM function calculates the total of numerical values within a specified column or expression. It is commonly used for aggregating sales figures, revenue, quantities, or any other numerical data.<\/p>\n\n\n\n<p>Example Formula: <img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXf0Na1O9KhYT-IIxXcsoXAXgk2srV2gHNPg8rPPPwIqvUNXdAt1cRnBZ1Y4kES9Q57IGJfSdWWwZZgVONoCq9Pa-gOwq1bp30IPyFW3gagRgfN3HEdUv9sqnDTH5YHrrd2Gb6kYQA?key=3E7EoAGK4ZfgxsXYM8_Gyo4c\" style=\"\" alt=\"code for SUM formula\"><\/p>\n\n\n\n<p>This formula sums up all the values in the &#8220;Amount&#8221; column of your &#8220;Sales&#8221; table.<\/p>\n\n\n\n<h4 id=\"average-function\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"AVERAGE_Function\"><\/span><strong>AVERAGE Function<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>The AVERAGE function computes the arithmetic mean of numerical values within a specified column or expression. It is useful for determining the typical value or central tendency of a dataset.<\/p>\n\n\n\n<p><strong>Example Formula:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXcLjQtThV1SJVo7Yyyksna177IsJsI0ZX-6H9AubWcWtKuThhtKzS9fUvcsIagVPThDJK-w15EUay7-m-HkTjIr5t2q8fE35iD4ag5aRQX-cifDB-3ZA5mANRgt-PTv60erSXzg?key=3E7EoAGK4ZfgxsXYM8_Gyo4c\" alt=\"code for AVERAGE Function\"\/><\/figure>\n\n\n\n<p>This formula calculates the average price of products in your dataset.<\/p>\n\n\n\n<h4 id=\"count-function\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"COUNT_Function\"><\/span><strong>COUNT Function<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>The <a href=\"https:\/\/pickl.ai\/blog\/how-to-use-count-in-excel-a-guide-to-the-count-function\/\">COUNT function<\/a> tallies the number of non-blank values within a specified column or expression. It is invaluable for determining the cardinality or frequency of occurrences within a dataset.<\/p>\n\n\n\n<p><strong>Example Formula<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXf7Q-OmDWkYNjbXn6J05c-ClMYptLxAiCVAaKfTiL42RHucFTR6d1Ad4tvphuCQ9JeMX4J0apxHNRVpZs7xISZNf2SCvT7LFnZ49ZEO_KHmNXv4XSQCw0JUcItNo0n1YPtzu1zaPA?key=3E7EoAGK4ZfgxsXYM8_Gyo4c\" alt=\"formula of COUNT Function\"\/><\/figure>\n\n\n\n<p>This formula counts the number of unique customer IDs in your dataset.<\/p>\n\n\n\n<h4 id=\"max-and-min-functions\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"MAX_and_MIN_Functions\"><\/span><strong>MAX and MIN Functions<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>These functions identify the maximum and minimum values within a specified column or expression, respectively. They are instrumental for identifying outliers, extreme values, or boundary conditions within datasets.<\/p>\n\n\n\n<p><strong>Example Formulas<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXdeeQrDnnRhqlvvfLmaYH6GptkMPQ_Fkg1-gJWkKEX866f6NRdkH6BBEpteFBpKtjk4J2GtQRyPFNZMo23yE7Cm5UbBWau1_duBENHmmVNhQWBjHM-Mc_qR5D6-y5TihQPddHSnLA?key=3E7EoAGK4ZfgxsXYM8_Gyo4c\" alt=\"formula of MAX and MIN Functions\"\/><\/figure>\n\n\n\n<p>These formulas find the highest and lowest sales amounts in your dataset.<\/p>\n\n\n\n<h4 id=\"distinctcount-function\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"DISTINCTCOUNT_Function\"><\/span><strong>DISTINCTCOUNT Function<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>The DISTINCTCOUNT function counts the number of unique values in a column. It is useful for determining the variety of items or categories in your dataset.<\/p>\n\n\n\n<p><strong>Example Formula<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXfXCY5JTiS1PAkqvcUto6BNEW-yhwkvd3h9ljZVKI-L6HyacjwIX42XfyFeAbIdgeTgyhG8MVlt3pOsFUYkOyYJ-X50gXyDNEnbxGZgcjibsjA25LwEF4RKXBiKWAaEQ9iYfq3jRg?key=3E7EoAGK4ZfgxsXYM8_Gyo4c\" alt=\"DISTINCTCOUNT Function\"\/><\/figure>\n\n\n\n<p>This formula counts the number of unique product names in your dataset.<\/p>\n\n\n\n<h4 id=\"practical-use-case\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Practical_Use_Case\"><\/span><strong>Practical Use Case<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Suppose you have a dataset with sales data for different regions. You want to calculate the total sales, average sales per region, and the number of regions.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Total Sales:<\/strong> Total Sales = SUM(Sales[Amount]).<\/li>\n\n\n\n<li><strong>Average Sales per Region:<\/strong> Average Sales per Region = AVERAGE(Sales[Amount]).<\/li>\n\n\n\n<li><strong>Number of Regions:<\/strong> Number of Regions = COUNT(DISTINCT Sales[Region]).<\/li>\n<\/ol>\n\n\n\n<h2 id=\"advanced-dax-concepts\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Advanced_DAX_Concepts\"><\/span><strong>Advanced DAX Concepts<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>As you progress in using DAX for Data Analysis in Power BI, understanding advanced concepts becomes crucial for creating complex calculations and models. Here are some key advanced DAX concepts that can enhance your analytical capabilities:<\/p>\n\n\n\n<h3 id=\"iterator-functions\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Iterator_Functions\"><\/span><strong>Iterator Functions<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Iterator functions in DAX, such as SUMX, AVERAGEX, and MAXX, allow you to perform calculations over a table by iterating over each row. These functions are particularly useful for complex operations where context is essential.<\/p>\n\n\n\n<p>Example Formula:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXdN2nOyneCly1o_Zf4mUQmWqBQrMGVH85ZkDtrwBRWv4ixIXWGCz66KKX3ZDqAOOSmL37FNQs_fTYtF3j9wTn_KYrMiw1zbiXkndsca1t90r8OsPbGaswfzBWcYKGc-vwsYnUDVkQ?key=3E7EoAGK4ZfgxsXYM8_Gyo4c\" alt=\" AVERAGE Function\"\/><\/figure>\n\n\n\n<p>This formula calculates the average discount per transaction by iterating over the &#8220;Sales&#8221; table.<\/p>\n\n\n\n<h3 id=\"calculate-statement-with-modifiers\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"CALCULATE_Statement_with_Modifiers\"><\/span><strong>CALCULATE Statement with Modifiers<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>The CALCULATE function is a powerful tool for manipulating the filter context in which a calculation is performed. It can be used with modifiers like ALL, FILTER, and KEEPFILTERS to change the context dynamically.<\/p>\n\n\n\n<p><strong>Example Formula:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXcFuj5GdmyG_iC7rsTlK4fhPYghtCz7-AKMIS5L5ti5JLopRzJSZJlC_lZQf_qKQbiJ07DUdu_um9FBGrGl2xc-SPlvkFN4wwDcHIL5gPY0Y481gg8QLh1rq8jhn6-rroZKMxl1jw?key=3E7EoAGK4ZfgxsXYM8_Gyo4c\" alt=\"CALCULATE Function\"\/><\/figure>\n\n\n\n<p>This formula calculates the sales for the current year by filtering the dates table.<\/p>\n\n\n\n<h3 id=\"time-intelligence-functions\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Time_Intelligence_Functions\"><\/span><strong>Time Intelligence Functions<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Time intelligence functions in DAX enable dynamic calculations over time, such as calculating year-over-year changes or same-period-last-year comparisons. Functions like SAMEPERIODLASTYEAR and PREVIOUSYEAR are commonly use.<\/p>\n\n\n\n<p><strong>Example Formula:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXcRBlYlvhhBzTWueYdWdCs_EPv-apuUA5cOsjFwWHQtEHoiI-Lg7Rig5uxdWmx9vjKw0E7nCK9MivNypilYkk-ow5gSTgT-mp5zQJfAvWNEcDv_-D7TUROgmSsJr8HhDnl0pLSdjA?key=3E7EoAGK4ZfgxsXYM8_Gyo4c\" alt=\"TIME INTELLIGENCE FUNCTION\"\/><\/figure>\n\n\n\n<p>This formula calculates the year-over-year growth in sales.<\/p>\n\n\n\n<h3 id=\"calculated-tables\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Calculated_Tables\"><\/span><strong>Calculated Tables<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Calculated tables entirely generate by DAX and can use to support complex analytics scenarios. They are useful for creating temporary data structures that can use in reports without affecting the original data model.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXfcEti2gf0FyNUaizNUulGRNCpY83jM4BLqlxwB1at2lym7SlrlI8XYVwdvJCmOr8dGkAdpQ3iLX6QWs3MYzdSJnHf7-Oq42b70-MUf-Ssy6v6tkkGHUCb4mAiw2IkxwE4Ia82PNQ?key=3E7EoAGK4ZfgxsXYM8_Gyo4c\" alt=\"Calculate Tables\"\/><\/figure>\n\n\n\n<p>This formula creates a calculated table showing the top 10 products by sales.<\/p>\n\n\n\n<h3 id=\"relationship-functions\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Relationship_Functions\"><\/span><strong>Relationship Functions<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Relationship functions in DAX allow you to manipulate and analyse data across related tables. Understanding how to use these functions is crucial for creating robust data models.<\/p>\n\n\n\n<p><strong>Example Formula:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXcM7z2_eWybVSHhpUJgj82uUe78R1lJU7-PT_c89mtoSfnpkS5F264TAIPw5sYCUj6zegegnuqVPY6TGfVbQQ1Q9t_SuStrS5sJFSj_QEoZdheoR75ZMIRYOvUUNFd0tIVtuOlBiQ?key=3E7EoAGK4ZfgxsXYM8_Gyo4c\" alt=\"CALCULATE Function for Sales\"\/><\/figure>\n\n\n\n<p>This formula calculates sales related to another table through a defined relationship.<\/p>\n\n\n\n<h2 id=\"conclusion\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span><strong>Conclusion<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>DAX is a powerful tool for Data Analysis in Power BI, enabling users to create complex calculations and insights. By mastering DAX, you can unlock the full potential of Power BI and drive business decisions with data-driven insights.<\/p>\n\n\n\n<h2 id=\"frequently-asked-questions\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Frequently_Asked_Questions\"><\/span><strong>Frequently Asked Questions<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 id=\"what-is-dax-used-for-in-power-bi\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"What_Is_DAX_Used_for_In_Power_BI\"><\/span><strong>What Is DAX Used for In Power BI?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>DAX used to create custom calculations and measures, enhancing Data Analysis capabilities in Power BI.<\/p>\n\n\n\n<h3 id=\"how-does-dax-differ-from-excel-formulas\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"How_Does_DAX_Differ_from_Excel_Formulas\"><\/span><strong>How Does DAX Differ from Excel Formulas?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>While similar, DAX is design for data models and offers more advanced functions for complex Data Analysis.<\/p>\n\n\n\n<h3 id=\"what-are-the-benefits-of-learning-dax\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"What_are_the_Benefits_of_Learning_DAX\"><\/span><strong>What are the Benefits of Learning DAX?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Learning DAX allows you to perform advanced Data Analysis, solve business problems, and maximize the potential of Power BI.<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":" Comprehensive guide to Power BI DAX basics for enhanced Data Analysis.\n","protected":false},"author":4,"featured_media":20406,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[2293],"tags":[3837],"ppma_author":[2169,2604],"class_list":{"0":"post-20405","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-power-bi","8":"tag-power-bi-dax"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.3 (Yoast SEO v27.3) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Power BI DAX Tutorial for Beginners<\/title>\n<meta name=\"description\" content=\"Power BI DAX basics with this beginner-friendly tutorial, covering essential concepts and functions to enhance your Data Analysis skills.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.pickl.ai\/blog\/power-bi-dax\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Power BI DAX Tutorial for Beginners\" \/>\n<meta property=\"og:description\" content=\"Power BI DAX basics with this beginner-friendly tutorial, covering essential concepts and functions to enhance your Data Analysis skills.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.pickl.ai\/blog\/power-bi-dax\/\" \/>\n<meta property=\"og:site_name\" content=\"Pickl.AI\" \/>\n<meta property=\"article:published_time\" content=\"2025-03-17T09:22:06+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-03-17T09:22:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2025\/03\/image2-6.png\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"500\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Neha Singh, Abhinav Anand\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Neha Singh\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/power-bi-dax\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/power-bi-dax\\\/\"},\"author\":{\"name\":\"Neha Singh\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#\\\/schema\\\/person\\\/2ad633a6bc1b93bc13591b60895be308\"},\"headline\":\"Power BI DAX Tutorial for Beginners\",\"datePublished\":\"2025-03-17T09:22:06+00:00\",\"dateModified\":\"2025-03-17T09:22:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/power-bi-dax\\\/\"},\"wordCount\":1559,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/power-bi-dax\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/image2-6.png\",\"keywords\":[\"Power BI DAX\"],\"articleSection\":[\"Power BI\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/power-bi-dax\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/power-bi-dax\\\/\",\"url\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/power-bi-dax\\\/\",\"name\":\"Power BI DAX Tutorial for Beginners\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/power-bi-dax\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/power-bi-dax\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/image2-6.png\",\"datePublished\":\"2025-03-17T09:22:06+00:00\",\"dateModified\":\"2025-03-17T09:22:07+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#\\\/schema\\\/person\\\/2ad633a6bc1b93bc13591b60895be308\"},\"description\":\"Power BI DAX basics with this beginner-friendly tutorial, covering essential concepts and functions to enhance your Data Analysis skills.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/power-bi-dax\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/power-bi-dax\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/power-bi-dax\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/image2-6.png\",\"contentUrl\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/image2-6.png\",\"width\":800,\"height\":500,\"caption\":\"power bi dax\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/power-bi-dax\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Power BI\",\"item\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/category\\\/power-bi\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Power BI DAX Tutorial for Beginners\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/\",\"name\":\"Pickl.AI\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#\\\/schema\\\/person\\\/2ad633a6bc1b93bc13591b60895be308\",\"name\":\"Neha Singh\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/06\\\/avatar_user_4_1717572961-96x96.jpg3d1a0d35d7a1a929f4a120e9053cbdb5\",\"url\":\"https:\\\/\\\/pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/06\\\/avatar_user_4_1717572961-96x96.jpg\",\"contentUrl\":\"https:\\\/\\\/pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/06\\\/avatar_user_4_1717572961-96x96.jpg\",\"caption\":\"Neha Singh\"},\"description\":\"I\u2019m a full-time freelance writer and editor who enjoys wordsmithing. The 8 years long journey as a content writer and editor has made me relaize the significance and power of choosing the right words. Prior to my writing journey, I was a trainer and human resource manager. WIth more than a decade long professional journey, I find myself more powerful as a wordsmith. As an avid writer, everything around me inspires me and pushes me to string words and ideas to create unique content; and when I\u2019m not writing and editing, I enjoy experimenting with my culinary skills, reading, gardening, and spending time with my adorable little mutt Neel.\",\"url\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/author\\\/nehasingh\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Power BI DAX Tutorial for Beginners","description":"Power BI DAX basics with this beginner-friendly tutorial, covering essential concepts and functions to enhance your Data Analysis skills.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.pickl.ai\/blog\/power-bi-dax\/","og_locale":"en_US","og_type":"article","og_title":"Power BI DAX Tutorial for Beginners","og_description":"Power BI DAX basics with this beginner-friendly tutorial, covering essential concepts and functions to enhance your Data Analysis skills.","og_url":"https:\/\/www.pickl.ai\/blog\/power-bi-dax\/","og_site_name":"Pickl.AI","article_published_time":"2025-03-17T09:22:06+00:00","article_modified_time":"2025-03-17T09:22:07+00:00","og_image":[{"width":800,"height":500,"url":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2025\/03\/image2-6.png","type":"image\/png"}],"author":"Neha Singh, Abhinav Anand","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Neha Singh","Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.pickl.ai\/blog\/power-bi-dax\/#article","isPartOf":{"@id":"https:\/\/www.pickl.ai\/blog\/power-bi-dax\/"},"author":{"name":"Neha Singh","@id":"https:\/\/www.pickl.ai\/blog\/#\/schema\/person\/2ad633a6bc1b93bc13591b60895be308"},"headline":"Power BI DAX Tutorial for Beginners","datePublished":"2025-03-17T09:22:06+00:00","dateModified":"2025-03-17T09:22:07+00:00","mainEntityOfPage":{"@id":"https:\/\/www.pickl.ai\/blog\/power-bi-dax\/"},"wordCount":1559,"commentCount":0,"image":{"@id":"https:\/\/www.pickl.ai\/blog\/power-bi-dax\/#primaryimage"},"thumbnailUrl":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2025\/03\/image2-6.png","keywords":["Power BI DAX"],"articleSection":["Power BI"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.pickl.ai\/blog\/power-bi-dax\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.pickl.ai\/blog\/power-bi-dax\/","url":"https:\/\/www.pickl.ai\/blog\/power-bi-dax\/","name":"Power BI DAX Tutorial for Beginners","isPartOf":{"@id":"https:\/\/www.pickl.ai\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.pickl.ai\/blog\/power-bi-dax\/#primaryimage"},"image":{"@id":"https:\/\/www.pickl.ai\/blog\/power-bi-dax\/#primaryimage"},"thumbnailUrl":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2025\/03\/image2-6.png","datePublished":"2025-03-17T09:22:06+00:00","dateModified":"2025-03-17T09:22:07+00:00","author":{"@id":"https:\/\/www.pickl.ai\/blog\/#\/schema\/person\/2ad633a6bc1b93bc13591b60895be308"},"description":"Power BI DAX basics with this beginner-friendly tutorial, covering essential concepts and functions to enhance your Data Analysis skills.","breadcrumb":{"@id":"https:\/\/www.pickl.ai\/blog\/power-bi-dax\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.pickl.ai\/blog\/power-bi-dax\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.pickl.ai\/blog\/power-bi-dax\/#primaryimage","url":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2025\/03\/image2-6.png","contentUrl":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2025\/03\/image2-6.png","width":800,"height":500,"caption":"power bi dax"},{"@type":"BreadcrumbList","@id":"https:\/\/www.pickl.ai\/blog\/power-bi-dax\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.pickl.ai\/blog\/"},{"@type":"ListItem","position":2,"name":"Power BI","item":"https:\/\/www.pickl.ai\/blog\/category\/power-bi\/"},{"@type":"ListItem","position":3,"name":"Power BI DAX Tutorial for Beginners"}]},{"@type":"WebSite","@id":"https:\/\/www.pickl.ai\/blog\/#website","url":"https:\/\/www.pickl.ai\/blog\/","name":"Pickl.AI","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.pickl.ai\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.pickl.ai\/blog\/#\/schema\/person\/2ad633a6bc1b93bc13591b60895be308","name":"Neha Singh","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/06\/avatar_user_4_1717572961-96x96.jpg3d1a0d35d7a1a929f4a120e9053cbdb5","url":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/06\/avatar_user_4_1717572961-96x96.jpg","contentUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/06\/avatar_user_4_1717572961-96x96.jpg","caption":"Neha Singh"},"description":"I\u2019m a full-time freelance writer and editor who enjoys wordsmithing. The 8 years long journey as a content writer and editor has made me relaize the significance and power of choosing the right words. Prior to my writing journey, I was a trainer and human resource manager. WIth more than a decade long professional journey, I find myself more powerful as a wordsmith. As an avid writer, everything around me inspires me and pushes me to string words and ideas to create unique content; and when I\u2019m not writing and editing, I enjoy experimenting with my culinary skills, reading, gardening, and spending time with my adorable little mutt Neel.","url":"https:\/\/www.pickl.ai\/blog\/author\/nehasingh\/"}]}},"jetpack_featured_media_url":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2025\/03\/image2-6.png","authors":[{"term_id":2169,"user_id":4,"is_guest":0,"slug":"nehasingh","display_name":"Neha Singh","avatar_url":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/06\/avatar_user_4_1717572961-96x96.jpg","first_name":"Neha","user_url":"","last_name":"Singh","description":"I\u2019m a full-time freelance writer and editor who enjoys wordsmithing. The 8 years long journey as a content writer and editor has made me relaize the significance and power of choosing the right words. Prior to my writing journey, I was a trainer and human resource manager. WIth more than a decade long professional journey, I find myself more powerful as a wordsmith. As an avid writer, everything around me inspires me and pushes me to string words and ideas to create unique content; and when I\u2019m not writing and editing, I enjoy experimenting with my culinary skills, reading, gardening, and spending time with my adorable little mutt Neel."},{"term_id":2604,"user_id":44,"is_guest":0,"slug":"abhinavanand","display_name":"Abhinav Anand","avatar_url":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/07\/avatar_user_44_1721991827-96x96.jpeg","first_name":"Abhinav","user_url":"","last_name":"Anand","description":"Abhinav Anand expertise lies in Data Analysis and SQL, Python and Data Science. Abhinav Anand graduated from IIT (BHU) Varanansi in Electrical Engineering  and did his masters from IIT (BHU) Varanasi. Abhinav has hobbies like Photography,Travelling and narrating stories."}],"_links":{"self":[{"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/posts\/20405","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/comments?post=20405"}],"version-history":[{"count":1,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/posts\/20405\/revisions"}],"predecessor-version":[{"id":20407,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/posts\/20405\/revisions\/20407"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/media\/20406"}],"wp:attachment":[{"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/media?parent=20405"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/categories?post=20405"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/tags?post=20405"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/ppma_author?post=20405"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}