{"id":169949,"date":"2023-08-31T09:24:49","date_gmt":"2023-08-31T08:24:49","guid":{"rendered":"https:\/\/datascientest.com\/en\/?p=169949"},"modified":"2023-10-30T19:47:38","modified_gmt":"2023-10-30T18:47:38","slug":"dax-power-bi-all-about-the-query-programming-language","status":"publish","type":"post","link":"https:\/\/datascientest.com\/en\/dax-power-bi-all-about-the-query-programming-language","title":{"rendered":"DAX Power BI: all about the query programming language"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"169949\" class=\"elementor elementor-169949\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-71d62d5 e-flex e-con-boxed e-con\" data-id=\"71d62d5\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-e836150 elementor-widget elementor-widget-heading\" data-id=\"e836150\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">Microsoft's Power BI platform is dedicated to business intelligence, data analysis and data visualization. This software tool provides real-time analysis in the form of visualizations. Although intuitive to use, it is often necessary to create formulas and expressions to analyze data. To do this, we use DAX. The DAX or Data Analysis Expressions language is used to create formulas and expressions in Power BI and various data analysis services such as Microsoft SQL Server or Excel Power Pivot. It offers great flexibility for data analysis tasks.<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-d3ec451 e-flex e-con-boxed e-con\" data-id=\"d3ec451\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-8a03dd9 elementor-widget elementor-widget-heading\" data-id=\"8a03dd9\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">What is Power BI?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-aca8e09 elementor-widget elementor-widget-text-editor\" data-id=\"aca8e09\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p><span style=\"font-weight: 400;\">Power BI is a <a href=\"https:\/\/datascientest.com\/en\/introduction-to-business-intelligence\" target=\"_blank\" rel=\"noopener\">Business Intelligence<\/a> tool and <strong>Data Visualization platform<\/strong> from <a href=\"https:\/\/www.microsoft.com\/en-us\" target=\"_blank\" rel=\"noopener\">Microsoft<\/a>. It enables organizations to analyze data and generate reports.<br \/><\/span><span style=\"font-weight: 400;\">Power BI comes with a wide range of tools, applications and connectors to d<strong>eliver actionable insights, immersive visuals and interactive reports<\/strong>.<br \/><\/span><span style=\"font-weight: 400;\">It&#8217;s a <strong>self-service Business Intelligence platform<\/strong>. This means it&#8217;s easy to aggregate, analyze and visualize data, and produce high-quality reports. <\/span><span style=\"font-weight: 400;\">Data can be extracted from multiple sources such as <strong>Oracle<\/strong>, <strong>SAP<\/strong> or <strong>any data warehouse<\/strong>. Different types of data are supported, from simple <strong>Excel<\/strong> <strong>files<\/strong> to vast volumes of Big Data.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d95e248 elementor-widget__width-initial elementor-widget elementor-widget-image\" data-id=\"d95e248\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"369\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/08\/sources-donnees-dax-power-bi.png\" class=\"attachment-large size-large wp-image-169952\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2023\/08\/sources-donnees-dax-power-bi.png 1024w, https:\/\/datascientest.com\/en\/files\/2023\/08\/sources-donnees-dax-power-bi-300x138.png 300w, https:\/\/datascientest.com\/en\/files\/2023\/08\/sources-donnees-dax-power-bi-768x354.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9a10640 elementor-widget elementor-widget-text-editor\" data-id=\"9a10640\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Power BI&#8217;s extensive functionality enables you to create <\/span><b>charts<\/b><span style=\"font-weight: 400;\">, <\/span><b>diagrams<\/b><span style=\"font-weight: 400;\">, <\/span><b>dashboards <\/b><span style=\"font-weight: 400;\">and <\/span><b>reports <\/b><span style=\"font-weight: 400;\">to analyze data and measure key performance indicators.<br \/><\/span><span style=\"font-weight: 400;\">Power BI can be used as <strong>local software with Power BI Desktop<\/strong>, or as a <strong>Cloud service<\/strong> with Power BI Service. Mobile applications for iOS and Android are also available.<\/span><\/p><p><span style=\"font-weight: 400;\">With the latest versions of Power BI, artificial intelligence features make it possible to deploy techniques such as image recognition or text analysis, <strong>develop Machine Learning models<\/strong>, and easily extract insights from structured or unstructured data.<br \/><\/span><span style=\"font-weight: 400;\">Power BI&#8217;s key benefits include simple integration thanks to data connectors, artificial intelligence features, report sharing tools, real-time dashboards and <strong>customizable<\/strong> <strong>visualizations<\/strong>.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2bb5295 elementor-align-center button-principal elementor-widget elementor-widget-button\" data-id=\"2bb5295\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-md\" href=\"https:\/\/datascientest.com\/en\/power-bi-training\" target=\"_blank\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Get to know about more about the training<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-499e9c3 e-flex e-con-boxed e-con\" data-id=\"499e9c3\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-ff6f516 elementor-widget elementor-widget-heading\" data-id=\"ff6f516\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">What is Power BI DAX?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6520b30 elementor-widget elementor-widget-text-editor\" data-id=\"6520b30\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">The DAX (Data Analysis Expression) language lets you <strong>perform specific data analysis tasks using predefined codes<\/strong>. It can be used with Power BI, Microsoft SQL Server and Excel Power Pivot.<br \/><\/span><span style=\"font-weight: 400;\">All in all, the DAX Library brings together over 200 functions, operators and constants to provide the <strong>ultimate in data analysis flexibility<\/strong>. New functions are added regularly.<br \/><\/span><span style=\"font-weight: 400;\">While it&#8217;s fairly easy to create reports from data with Power BI, the task can become complicated for complex analyses. That&#8217;s why we use DAX.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-6ed7d6c e-flex e-con-boxed e-con\" data-id=\"6ed7d6c\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-dc51506 elementor-widget elementor-widget-heading\" data-id=\"dc51506\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">How do I learn to use DAX Power BI?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-687f4d1 elementor-widget elementor-widget-text-editor\" data-id=\"687f4d1\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Power BI is used by data professionals around the world to analyze data from multiple sources and create reports or dashboards. <strong>The tool offers data import, transformation, analysis and visualization capabilities for the entire Business Intelligence process<\/strong>.<br \/><\/span><span style=\"font-weight: 400;\">Mastering Power BI and the DAX language is a highly sought-after business skill. To discover the platform and learn DAX formulas, turn to DataScientest.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e5e3e67 elementor-widget__width-initial elementor-widget elementor-widget-image\" data-id=\"e5e3e67\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"388\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/08\/dax-power-bi-analyse.png\" class=\"attachment-large size-large wp-image-169959\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2023\/08\/dax-power-bi-analyse.png 1024w, https:\/\/datascientest.com\/en\/files\/2023\/08\/dax-power-bi-analyse-300x146.png 300w, https:\/\/datascientest.com\/en\/files\/2023\/08\/dax-power-bi-analyse-768x373.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-335b674 elementor-widget elementor-widget-text-editor\" data-id=\"335b674\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Our Power BI editor training course teaches you how to use the software in just five days. At the end of the course, you can take the PL-300 exam and obtain Microsoft Associate Data Analyst certification.<br \/><\/span><span style=\"font-weight: 400;\">The program modules cover a general introduction to Power BI, data transformation with <strong>Power Query, data modeling and the DAX language, data visualization and workspace management<\/strong>.<\/span><\/p><p><span style=\"font-weight: 400;\">By the end of the course, you&#8217;ll have mastered raw data analysis, data sorting and modification, transformed data modeling and dashboard creation. <strong>You&#8217;ll have all the skills you need to use Power BI and pass the PL-300 exam<\/strong>.<br \/><\/span><span style=\"font-weight: 400;\">All our training courses are distance learning. Don&#8217;t wait any longer and discover DataScientest&#8217;s Power BI training.<\/span><\/p><p><span style=\"font-weight: 400;\">You now know everything about Power BI DAX. For more information, see our complete dossier on Power BI.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d5423e0 elementor-align-center button-principal elementor-widget elementor-widget-button\" data-id=\"d5423e0\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-md\" href=\"https:\/\/datascientest.com\/en\/power-bi-training\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Discover our Power BI training<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Microsoft&#8217;s Power BI platform is dedicated to business intelligence, data analysis and data visualization. This software tool provides real-time analysis in the form of visualizations. Although intuitive to use, it is often necessary to create formulas and expressions to analyze data. To do this, we use DAX. The DAX or Data Analysis Expressions language is [&hellip;]<\/p>\n","protected":false},"author":45,"featured_media":169950,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2420],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>DAX Power BI: all about the programming language I DataScientest<\/title>\n<meta name=\"description\" content=\"Although intuitive to use, it is often necessary to create formulas and expressions to analyze data. To do this, we use DAX.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/en\/dax-power-bi-all-about-the-query-programming-language\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"DAX Power BI: all about the query programming language\" \/>\n<meta property=\"og:description\" content=\"Microsoft&#039;s Power BI platform is dedicated to business intelligence, data analysis and data visualization. This software tool provides real-time analysis\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/en\/dax-power-bi-all-about-the-query-programming-language\" \/>\n<meta property=\"og:site_name\" content=\"Data Science Courses | DataScientest\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataScientestEN\" \/>\n<meta property=\"article:published_time\" content=\"2023-08-31T08:24:49+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-30T18:47:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/en\/files\/2023\/08\/dax-power-bi.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"498\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Daniel\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:site\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Daniel\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/datascientest.com\/en\/dax-power-bi-all-about-the-query-programming-language#article\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/dax-power-bi-all-about-the-query-programming-language\"},\"author\":{\"name\":\"Daniel\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/5a86e30c5090234fb43dd8baa83c44b0\"},\"headline\":\"DAX Power BI: all about the query programming language\",\"datePublished\":\"2023-08-31T08:24:49+00:00\",\"dateModified\":\"2023-10-30T18:47:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/datascientest.com\/en\/dax-power-bi-all-about-the-query-programming-language\"},\"wordCount\":606,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"articleSection\":[\"Business Intelligence\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/datascientest.com\/en\/dax-power-bi-all-about-the-query-programming-language#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\/\/datascientest.com\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/en\/dax-power-bi-all-about-the-query-programming-language\",\"url\":\"https:\/\/datascientest.com\/en\/dax-power-bi-all-about-the-query-programming-language\",\"name\":\"DAX Power BI: all about the programming language I DataScientest\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/#website\"},\"datePublished\":\"2023-08-31T08:24:49+00:00\",\"dateModified\":\"2023-10-30T18:47:38+00:00\",\"description\":\"Although intuitive to use, it is often necessary to create formulas and expressions to analyze data. To do this, we use DAX.\",\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/en\/dax-power-bi-all-about-the-query-programming-language\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/en\/#website\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"name\":\"Data Science Courses | DataScientest\",\"description\":\"Leader in Data Science Courses\",\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/en\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/datascientest.com\/en\/#organization\",\"name\":\"DataScientest\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"contentUrl\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"width\":301,\"height\":301,\"caption\":\"DataScientest\"},\"image\":{\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/DataScientestEN\",\"https:\/\/twitter.com\/DataScientest__\",\"https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/\",\"https:\/\/www.tiktok.com\/@datascientest\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/5a86e30c5090234fb43dd8baa83c44b0\",\"name\":\"Daniel\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/837acad4f2dc47e85d81cce837261670?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/837acad4f2dc47e85d81cce837261670?s=96&d=mm&r=g\",\"caption\":\"Daniel\"},\"sameAs\":[\"https:\/\/www.linkedin.com\/school\/datascientest\/\",\"user\"],\"jobTitle\":\"ing\u00e9nieur logiciel\",\"worksFor\":\"DataScientest\",\"url\":\"https:\/\/datascientest.com\/en\/author\/team-redac\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"DAX Power BI: all about the programming language I DataScientest","description":"Although intuitive to use, it is often necessary to create formulas and expressions to analyze data. To do this, we use DAX.","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:\/\/datascientest.com\/en\/dax-power-bi-all-about-the-query-programming-language","og_locale":"en_GB","og_type":"article","og_title":"DAX Power BI: all about the query programming language","og_description":"Microsoft's Power BI platform is dedicated to business intelligence, data analysis and data visualization. This software tool provides real-time analysis","og_url":"https:\/\/datascientest.com\/en\/dax-power-bi-all-about-the-query-programming-language","og_site_name":"Data Science Courses | DataScientest","article_publisher":"https:\/\/www.facebook.com\/DataScientestEN","article_published_time":"2023-08-31T08:24:49+00:00","article_modified_time":"2023-10-30T18:47:38+00:00","og_image":[{"width":1024,"height":498,"url":"https:\/\/datascientest.com\/en\/files\/2023\/08\/dax-power-bi.png","type":"image\/png"}],"author":"Daniel","twitter_card":"summary_large_image","twitter_creator":"@DataScientest__","twitter_site":"@DataScientest__","twitter_misc":{"Written by":"Daniel","Estimated reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/datascientest.com\/en\/dax-power-bi-all-about-the-query-programming-language#article","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/dax-power-bi-all-about-the-query-programming-language"},"author":{"name":"Daniel","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/5a86e30c5090234fb43dd8baa83c44b0"},"headline":"DAX Power BI: all about the query programming language","datePublished":"2023-08-31T08:24:49+00:00","dateModified":"2023-10-30T18:47:38+00:00","mainEntityOfPage":{"@id":"https:\/\/datascientest.com\/en\/dax-power-bi-all-about-the-query-programming-language"},"wordCount":606,"commentCount":0,"publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"articleSection":["Business Intelligence"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/datascientest.com\/en\/dax-power-bi-all-about-the-query-programming-language#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/datascientest.com\/#organization"}},{"@type":"WebPage","@id":"https:\/\/datascientest.com\/en\/dax-power-bi-all-about-the-query-programming-language","url":"https:\/\/datascientest.com\/en\/dax-power-bi-all-about-the-query-programming-language","name":"DAX Power BI: all about the programming language I DataScientest","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/#website"},"datePublished":"2023-08-31T08:24:49+00:00","dateModified":"2023-10-30T18:47:38+00:00","description":"Although intuitive to use, it is often necessary to create formulas and expressions to analyze data. To do this, we use DAX.","inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/en\/dax-power-bi-all-about-the-query-programming-language"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/en\/#website","url":"https:\/\/datascientest.com\/en\/","name":"Data Science Courses | DataScientest","description":"Leader in Data Science Courses","publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/en\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/datascientest.com\/en\/#organization","name":"DataScientest","url":"https:\/\/datascientest.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","contentUrl":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","width":301,"height":301,"caption":"DataScientest"},"image":{"@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataScientestEN","https:\/\/twitter.com\/DataScientest__","https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/","https:\/\/www.tiktok.com\/@datascientest"]},{"@type":"Person","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/5a86e30c5090234fb43dd8baa83c44b0","name":"Daniel","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/837acad4f2dc47e85d81cce837261670?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/837acad4f2dc47e85d81cce837261670?s=96&d=mm&r=g","caption":"Daniel"},"sameAs":["https:\/\/www.linkedin.com\/school\/datascientest\/","user"],"jobTitle":"ing\u00e9nieur logiciel","worksFor":"DataScientest","url":"https:\/\/datascientest.com\/en\/author\/team-redac"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/169949"}],"collection":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/users\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/comments?post=169949"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/169949\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media\/169950"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media?parent=169949"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/categories?post=169949"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/tags?post=169949"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}