{"id":3361,"date":"2024-05-05T22:51:59","date_gmt":"2024-05-05T20:51:59","guid":{"rendered":"https:\/\/newdatalabs.com\/en\/?p=3361"},"modified":"2024-05-05T22:53:32","modified_gmt":"2024-05-05T20:53:32","slug":"practical-use-of-dax-language-in-power-bi","status":"publish","type":"post","link":"https:\/\/newdatalabs.com\/en\/practical-use-of-dax-language-in-power-bi\/","title":{"rendered":"Practical Use of DAX Language in Power BI"},"content":{"rendered":"\n<p>Dax is a basic language for building formulas in <a href=\"https:\/\/newdatalabs.com\/en\/power-bi\/\"><strong>Power BI<\/strong>.<\/a> The intelligent use of creating queries combined with the set of standard visualizations allows us to improve the quality of reports. The advantages of this solution are the simplicity of data analysis and the practical applications of visualizations.<\/p>\n\n\n\n<p>The use and development of the competences related to creating Dax queries can be divided into several key categories. The below categories will help you systematize knowledge in this regard.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Building tables<\/li>\n\n\n\n<li>Using measures<\/li>\n\n\n\n<li>Creating advanced visualizations<\/li>\n\n\n\n<li>Working with parameters<\/li>\n\n\n\n<li>Conditional formatting<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">DAX- building tables<\/h2>\n\n\n\n<p>Begin working on a report by preparing a good data model. For this reason, the first area touches on building tables using DAX formulas. The most common table allows you to prepare a calendar, and there are two methods to choose from. The first method uses the CALENDARAUTO function. It verifies all date columns and selects the minimum and maximum dates as the range of the calendar that is created. The second method allows you to determine the range by using the CALENDAR function. It enables you to specify the range of time to be taken into account. The best way is to provide at least a column with the year from the fact table, which will be used to create relationships and close the table by indicating the end of the next year. For example:<\/p>\n\n\n\n<p>CALENDAR(<\/p>\n\n\n\n<p>DATE(YEAR(MIN(Table[Column with date])),1,1),<\/p>\n\n\n\n<p>DATE(YEAR(TODAY())+1,12,31)<\/p>\n\n\n\n<p>)<\/p>\n\n\n\n<p>The new calendar can be further developed by adding new columns using such functions as MONTH, YEAR, DAY, WEEKDAY, and WEEKNUM etc.<\/p>\n\n\n\n<p>As shown in the above example, in the context of building one table using DAX, there are several ways to achieve the expected result. The flexibility of the formulas allows you to determine how specific your solution will be.<\/p>\n\n\n\n<p>Other formulas that can be used to build tables such as tables with measures are GROUPBY, SUMARAIZECOLUMN and CALCULATETABLE. If you want to combine several tables using DAX, you can do that with such calculations as UNION, CROSSJOIN, NATURALINERJOIN, and NATURALLEFTOUTERJOIN.<\/p>\n\n\n\n<p>With respect to the last calculation group, a question may arise as to for what purposes you could use the functionality of creating queries in DAX, which should be prepared at the stage of building a data source or performing transformations in Power Query. The answer would be to explore further the areas in which DAX language could be used. A less known area, in addition to working with DAX directly in Power BI, is to use it at the stage of connecting certain data sources. There are types of data sources such as SQL Server Analysis Services, where instead of creating formulas using MDX, you can do that with the help of DAX. <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"699\" height=\"509\" data-src=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/1.png\" alt=\"\" class=\"wp-image-3362 lazyload\" data-srcset=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/1.png 699w, https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/1-300x218.png 300w\" data-sizes=\"(max-width: 699px) 100vw, 699px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 699px; --smush-placeholder-aspect-ratio: 699\/509;\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>A further way of using tabular functions is to treat them as temporary tables. They are calculated inside the measure, for example to count the TOPN of elements. Such use of tables in measures, in combination with filters, will allow you to prepare detailed and effective calculations, without creating additional tables and managing the relationships between them.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">DAX- using measures<\/h2>\n\n\n\n<p>Another area where you could use DAX queries is to create measures. Power BI has prepared a set of default measures. They allow you to quickly prepare basic calculations, such as comparing YTD or YoY. The main advantage of quick measures is that they help users unfamiliar with this tool to build calculations through graphical interface without knowing DAX. <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"356\" height=\"91\" data-src=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/2.png\" alt=\"\" class=\"wp-image-3363 lazyload\" data-srcset=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/2.png 356w, https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/2-300x77.png 300w\" data-sizes=\"(max-width: 356px) 100vw, 356px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 356px; --smush-placeholder-aspect-ratio: 356\/91;\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"851\" height=\"315\" data-src=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/3.jpg\" alt=\"\" class=\"wp-image-3364 lazyload\" data-srcset=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/3.jpg 851w, https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/3-300x111.jpg 300w, https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/3-768x284.jpg 768w\" data-sizes=\"(max-width: 851px) 100vw, 851px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 851px; --smush-placeholder-aspect-ratio: 851\/315;\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>After getting to know quick measures, you usually develop a thirst for knowledge and want to further explore them \u2013 it\u2019s worthwhile to complete a training course on the subject. It is useful to be able to separate the most important formulas from the list of dozens available calculations. The most essential functions are those which allow us to change the context of the filters.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Creating advanced visualizations<\/h2>\n\n\n\n<p>Combing the measures and tables prepared in DAX allows you to take the reports to a higher level where you can further develop standard visualizations. It is worth to mention such functions as altering a matrix to create a Waffle Chart. <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"217\" height=\"150\" data-src=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/4.png\" alt=\"\" class=\"wp-image-3365 lazyload\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 217px; --smush-placeholder-aspect-ratio: 217\/150;\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Matrix, as a default visualization in Power BI, is a helpful object. It allows you to create ladders shaped to resemble sports competitions, or calendars presenting the level of the annual leaves taken. <\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img decoding=\"async\" width=\"775\" height=\"382\" data-src=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/5.png\" alt=\"\" class=\"wp-image-3366 lazyload\" style=\"--smush-placeholder-width: 775px; --smush-placeholder-aspect-ratio: 775\/382;width:840px;height:auto\" data-srcset=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/5.png 775w, https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/5-300x148.png 300w, https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/5-768x379.png 768w\" data-sizes=\"(max-width: 775px) 100vw, 775px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1024\" height=\"559\" data-src=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/6.png\" alt=\"\" class=\"wp-image-3367 lazyload\" data-srcset=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/6.png 1024w, https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/6-300x164.png 300w, https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/6-768x419.png 768w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/559;\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Another type of visualization which can be separated is the BCG Matrix that can be built by means of dynamic management of the axes in point charts. <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1024\" height=\"542\" data-src=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/7.png\" alt=\"\" class=\"wp-image-3368 lazyload\" data-srcset=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/7.png 1024w, https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/7-300x159.png 300w, https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/7-768x407.png 768w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/542;\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Creating parameters, altering default DAX formulas<\/h3>\n\n\n\n<p>When working with Power BI, a good practice is to use parameters. Until recently, only one type of parameter was available \u2013 the value parameter. This solution allowed us to primarily create such analyses as What IF. The greatest advantage of this parameter is that the end user can enter specified assumptions in the report. It now has as new parameter \u2013 &#8220;field\u201d \u2013 a text parameter that refers to the measures and dimensions used in the report. <\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img decoding=\"async\" width=\"746\" height=\"138\" data-src=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/8.png\" alt=\"\" class=\"wp-image-3369 lazyload\" style=\"--smush-placeholder-width: 746px; --smush-placeholder-aspect-ratio: 746\/138;width:840px;height:auto\" data-srcset=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/8.png 746w, https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/8-300x55.png 300w\" data-sizes=\"(max-width: 746px) 100vw, 746px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Parameters are automatically added, and if you are familiar with the DAX queries, you will be able to alter them once they are created.<\/p>\n\n\n\n<p>In the case of the value parameter, by modifying the GENERATESERIES you can change the properties set up at the stage of creating the parameter, such as the range of values and the minimum range. The below screen shows the creation of a parameter and the formula which reflects the underlying tables. I marked the maximum value with violet, and I adjusted it manually after adding the parameter. This allowed me to increase the maximum possibility to enter the value into the parameter field. <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"858\" height=\"745\" data-src=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/9.png\" alt=\"\" class=\"wp-image-3370 lazyload\" data-srcset=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/9.png 858w, https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/9-300x260.png 300w, https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/9-768x667.png 768w\" data-sizes=\"(max-width: 858px) 100vw, 858px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 858px; --smush-placeholder-aspect-ratio: 858\/745;\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>The new option in Power BI \u2013 the text parameter \u2013 also uses the DAX formula that can be edited at a later stage. The possibility to enter changes allows you to modify the names, but most of all, you can add new fields by coping the last line and replacing the name of the field and the related measure. The last step is to determine the order of the measure in the created list. <\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img decoding=\"async\" width=\"971\" height=\"116\" data-src=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/10.png\" alt=\"\" class=\"wp-image-3371 lazyload\" style=\"--smush-placeholder-width: 971px; --smush-placeholder-aspect-ratio: 971\/116;width:840px;height:auto\" data-srcset=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/10.png 971w, https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/10-300x36.png 300w, https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/10-768x92.png 768w, https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/10-960x116.png 960w\" data-sizes=\"(max-width: 971px) 100vw, 971px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>The below example demonstrates the practical use of the two text parameters combined. Firstly, you can see the sales volume in a monthly format. Next, with the use of parameter, the table and the chart were switched to the measure Target Performance of the sales volume in a quarterly format. Formatting is a helpful function when working with field parameters. It was not possible to use it in the previous solution, which was based on the SWITCH function, for example in the case of line charts. <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1024\" height=\"431\" data-src=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/11.png\" alt=\"\" class=\"wp-image-3372 lazyload\" data-srcset=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/11.png 1024w, https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/11-300x126.png 300w, https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/11-768x323.png 768w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/431;\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1024\" height=\"418\" data-src=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/12.png\" alt=\"\" class=\"wp-image-3373 lazyload\" data-srcset=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/12.png 1024w, https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/12-300x122.png 300w, https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/12-768x314.png 768w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/418;\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Conditional formatting using DAX<\/h3>\n\n\n\n<p>When writing about DAX, it\u2019s important to mention about the possibility to manage colors and icons from the level of formulas. It is possible to create a condition in the formula to change the colors by writing the name of the color in English. Another way to do this is to indicate the RGB code of any color corresponding to the color palette used in the report.<\/p>\n\n\n\n<p>Another functionality related to the formatting is the ability to change the icon placed, for example, under the KPI, by using the UNICHAR function. This solution enables you to use any icon, out of hundreds of pre-defined icons with numerical values assigned that you enter when creating a formula.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"603\" height=\"210\" data-src=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/13.jpg\" alt=\"\" class=\"wp-image-3374 lazyload\" data-srcset=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/13.jpg 603w, https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/13-300x104.jpg 300w\" data-sizes=\"(max-width: 603px) 100vw, 603px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 603px; --smush-placeholder-aspect-ratio: 603\/210;\" \/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">Summary<\/h4>\n\n\n\n<p>In the above post we have distinguished the key areas relating to the use of formulas prepared in DAX. There is a wide range of feasible options and often your imagination is your only limitation. The main advantage is the flexibility of formulas and the set of measures. They are designed in a way to allow inexperienced users of visualizations to prepare basic calculations and create functional reports, even without knowing how to use DAX. In my next posts I will present in more detail separate calculation groups.<\/p>\n\n\n\n<p>Micha\u0142 Niewiadomski Power BI Team Manager<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dax is a basic language for building formulas in Power BI. The intelligent use of creating queries combined with the set of standard visualizations allows us to improve the quality of reports. The advantages of this solution are the simplicity of data analysis and the practical applications of visualizations. The use and development of the [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":3375,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"content-sidebar","footnotes":""},"categories":[9,7],"tags":[],"class_list":{"0":"post-3361","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-blog","8":"category-power-bi","9":"entry"},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Practical Use of DAX Language in Power BI - NewDataLabs<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/newdatalabs.com\/en\/practical-use-of-dax-language-in-power-bi\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Practical Use of DAX Language in Power BI - NewDataLabs\" \/>\n<meta property=\"og:description\" content=\"Dax is a basic language for building formulas in Power BI. The intelligent use of creating queries combined with the set of standard visualizations allows us to improve the quality of reports. The advantages of this solution are the simplicity of data analysis and the practical applications of visualizations. The use and development of the [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/newdatalabs.com\/en\/practical-use-of-dax-language-in-power-bi\/\" \/>\n<meta property=\"og:site_name\" content=\"NewDataLabs\" \/>\n<meta property=\"article:published_time\" content=\"2024-05-05T20:51:59+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-05T20:53:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/fot.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"360\" \/>\n\t<meta property=\"og:image:height\" content=\"216\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Barbara\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Barbara\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/newdatalabs.com\/en\/practical-use-of-dax-language-in-power-bi\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/newdatalabs.com\/en\/practical-use-of-dax-language-in-power-bi\/\"},\"author\":{\"name\":\"Barbara\",\"@id\":\"https:\/\/newdatalabs.com\/en\/#\/schema\/person\/dfa2df2f2fb6fcecdd8f69f00cffba29\"},\"headline\":\"Practical Use of DAX Language in Power BI\",\"datePublished\":\"2024-05-05T20:51:59+00:00\",\"dateModified\":\"2024-05-05T20:53:32+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/newdatalabs.com\/en\/practical-use-of-dax-language-in-power-bi\/\"},\"wordCount\":1317,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/newdatalabs.com\/en\/practical-use-of-dax-language-in-power-bi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/fot.jpg\",\"articleSection\":[\"Blog\",\"Power-BI\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/newdatalabs.com\/en\/practical-use-of-dax-language-in-power-bi\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/newdatalabs.com\/en\/practical-use-of-dax-language-in-power-bi\/\",\"url\":\"https:\/\/newdatalabs.com\/en\/practical-use-of-dax-language-in-power-bi\/\",\"name\":\"Practical Use of DAX Language in Power BI - NewDataLabs\",\"isPartOf\":{\"@id\":\"https:\/\/newdatalabs.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/newdatalabs.com\/en\/practical-use-of-dax-language-in-power-bi\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/newdatalabs.com\/en\/practical-use-of-dax-language-in-power-bi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/fot.jpg\",\"datePublished\":\"2024-05-05T20:51:59+00:00\",\"dateModified\":\"2024-05-05T20:53:32+00:00\",\"author\":{\"@id\":\"https:\/\/newdatalabs.com\/en\/#\/schema\/person\/dfa2df2f2fb6fcecdd8f69f00cffba29\"},\"breadcrumb\":{\"@id\":\"https:\/\/newdatalabs.com\/en\/practical-use-of-dax-language-in-power-bi\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/newdatalabs.com\/en\/practical-use-of-dax-language-in-power-bi\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/newdatalabs.com\/en\/practical-use-of-dax-language-in-power-bi\/#primaryimage\",\"url\":\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/fot.jpg\",\"contentUrl\":\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/fot.jpg\",\"width\":360,\"height\":216},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/newdatalabs.com\/en\/practical-use-of-dax-language-in-power-bi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Strona g\u0142\u00f3wna\",\"item\":\"https:\/\/newdatalabs.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Practical Use of DAX Language in Power BI\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/newdatalabs.com\/en\/#website\",\"url\":\"https:\/\/newdatalabs.com\/en\/\",\"name\":\"NewDataLabs\",\"description\":\"Tableau - Business Intelligence Tools\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/newdatalabs.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/newdatalabs.com\/en\/#\/schema\/person\/dfa2df2f2fb6fcecdd8f69f00cffba29\",\"name\":\"Barbara\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/newdatalabs.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8805976098f215eb8413b85141c17705f7ac9d91ccc0f83881d7eae1eab8c7f1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8805976098f215eb8413b85141c17705f7ac9d91ccc0f83881d7eae1eab8c7f1?s=96&d=mm&r=g\",\"caption\":\"Barbara\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Practical Use of DAX Language in Power BI - NewDataLabs","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:\/\/newdatalabs.com\/en\/practical-use-of-dax-language-in-power-bi\/","og_locale":"en_US","og_type":"article","og_title":"Practical Use of DAX Language in Power BI - NewDataLabs","og_description":"Dax is a basic language for building formulas in Power BI. The intelligent use of creating queries combined with the set of standard visualizations allows us to improve the quality of reports. The advantages of this solution are the simplicity of data analysis and the practical applications of visualizations. The use and development of the [&hellip;]","og_url":"https:\/\/newdatalabs.com\/en\/practical-use-of-dax-language-in-power-bi\/","og_site_name":"NewDataLabs","article_published_time":"2024-05-05T20:51:59+00:00","article_modified_time":"2024-05-05T20:53:32+00:00","og_image":[{"width":360,"height":216,"url":"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/fot.jpg","type":"image\/jpeg"}],"author":"Barbara","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Barbara","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/newdatalabs.com\/en\/practical-use-of-dax-language-in-power-bi\/#article","isPartOf":{"@id":"https:\/\/newdatalabs.com\/en\/practical-use-of-dax-language-in-power-bi\/"},"author":{"name":"Barbara","@id":"https:\/\/newdatalabs.com\/en\/#\/schema\/person\/dfa2df2f2fb6fcecdd8f69f00cffba29"},"headline":"Practical Use of DAX Language in Power BI","datePublished":"2024-05-05T20:51:59+00:00","dateModified":"2024-05-05T20:53:32+00:00","mainEntityOfPage":{"@id":"https:\/\/newdatalabs.com\/en\/practical-use-of-dax-language-in-power-bi\/"},"wordCount":1317,"commentCount":0,"image":{"@id":"https:\/\/newdatalabs.com\/en\/practical-use-of-dax-language-in-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/fot.jpg","articleSection":["Blog","Power-BI"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/newdatalabs.com\/en\/practical-use-of-dax-language-in-power-bi\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/newdatalabs.com\/en\/practical-use-of-dax-language-in-power-bi\/","url":"https:\/\/newdatalabs.com\/en\/practical-use-of-dax-language-in-power-bi\/","name":"Practical Use of DAX Language in Power BI - NewDataLabs","isPartOf":{"@id":"https:\/\/newdatalabs.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/newdatalabs.com\/en\/practical-use-of-dax-language-in-power-bi\/#primaryimage"},"image":{"@id":"https:\/\/newdatalabs.com\/en\/practical-use-of-dax-language-in-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/fot.jpg","datePublished":"2024-05-05T20:51:59+00:00","dateModified":"2024-05-05T20:53:32+00:00","author":{"@id":"https:\/\/newdatalabs.com\/en\/#\/schema\/person\/dfa2df2f2fb6fcecdd8f69f00cffba29"},"breadcrumb":{"@id":"https:\/\/newdatalabs.com\/en\/practical-use-of-dax-language-in-power-bi\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/newdatalabs.com\/en\/practical-use-of-dax-language-in-power-bi\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/newdatalabs.com\/en\/practical-use-of-dax-language-in-power-bi\/#primaryimage","url":"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/fot.jpg","contentUrl":"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/fot.jpg","width":360,"height":216},{"@type":"BreadcrumbList","@id":"https:\/\/newdatalabs.com\/en\/practical-use-of-dax-language-in-power-bi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Strona g\u0142\u00f3wna","item":"https:\/\/newdatalabs.com\/en\/"},{"@type":"ListItem","position":2,"name":"Practical Use of DAX Language in Power BI"}]},{"@type":"WebSite","@id":"https:\/\/newdatalabs.com\/en\/#website","url":"https:\/\/newdatalabs.com\/en\/","name":"NewDataLabs","description":"Tableau - Business Intelligence Tools","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/newdatalabs.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/newdatalabs.com\/en\/#\/schema\/person\/dfa2df2f2fb6fcecdd8f69f00cffba29","name":"Barbara","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/newdatalabs.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8805976098f215eb8413b85141c17705f7ac9d91ccc0f83881d7eae1eab8c7f1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8805976098f215eb8413b85141c17705f7ac9d91ccc0f83881d7eae1eab8c7f1?s=96&d=mm&r=g","caption":"Barbara"}}]}},"_links":{"self":[{"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/posts\/3361","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/comments?post=3361"}],"version-history":[{"count":4,"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/posts\/3361\/revisions"}],"predecessor-version":[{"id":3380,"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/posts\/3361\/revisions\/3380"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/media\/3375"}],"wp:attachment":[{"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/media?parent=3361"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/categories?post=3361"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/tags?post=3361"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}