{"id":6891,"date":"2022-03-21T06:15:00","date_gmt":"2022-03-21T05:15:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=6891"},"modified":"2022-04-23T16:33:25","modified_gmt":"2022-04-23T14:33:25","slug":"dax-signifie-data-analysis-expressions","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/concepts\/dax-signifie-data-analysis-expressions\/","title":{"rendered":"DAX signifie Data Analysis Expressions"},"content":{"rendered":"\n<p><strong>DAX signifie Data Analysis Expressions, c&rsquo;est le langage de Microsoft pour manipuler les donn\u00e9es dans les cubes Microsoft SSAS Tabular ainsi que dans Power BI, et aussi dans Excel PowerPivot.<\/strong><\/p>\n\n\n\n<p>La biblioth\u00e8que DAX est une biblioth\u00e8que Microsoft puissante et conviviale de diff\u00e9rents types de fonctions r\u00e9pondant \u00e0 diff\u00e9rents objectifs. En effet elle est tr\u00e8s intuitive et permet \u00e0 des non informaticiens de cr\u00e9er des formules.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-definition-du-langage-informatique-dax-pour-data-analysis-expressions\">D\u00e9finition du langage informatique DAX pour Data Analysis Expressions<\/h2>\n\n\n\n<p>Les fonctions DAX peuvent \u00eatre des fonctions d&rsquo;intelligence temporelle ou des fonctions de filtrage par exemple. Data Analysis Expressions combine ces fonctions avec des op\u00e9rateurs dans des formules pour construire des expressions permettant de manipuler des donn\u00e9es.<\/p>\n\n\n\n<p>Les fonctions <a href=\"https:\/\/docs.microsoft.com\/fr-fr\/power-bi\/transform-model\/desktop-quickstart-learn-dax-basics\" target=\"_blank\" rel=\"noreferrer noopener\">DAX<\/a><strong> <\/strong>pour <strong>Data Analysis Expression<\/strong> peuvent \u00eatre des fonctions d&rsquo;intelligence temporelle ou des fonctions de filtrage, par exemple. Les Expressions d&rsquo;Analyse de Donn\u00e9es combinent ces fonctions avec des op\u00e9rateurs dans des formules pour construire des expressions permettant de manipuler des donn\u00e9es.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Exemples de types de fonctions DAX des outils d&rsquo;analyse tr\u00e8s puissants<\/h3>\n\n\n\n<p>Cette liste n&rsquo;est pas exhaustive mais simplement quelques exemples des fonctions qu&rsquo;offre le langage DAX :<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Fonctions d&rsquo;agr\u00e9gations<\/strong> comme SUM ou AVERAGE<\/li><li><strong>Fonctions de date et d&rsquo;heure<\/strong> comme TODAY, DATEDIFF, MONTH ou QUARTER.<\/li><li><strong>Les fonctions textes<\/strong> comme REPLACE, CONCATENATE et FORMAT.<\/li><li>Les tr\u00e8s innovantes <strong>fonctions d&rsquo;intelligence temporelle<\/strong> telles que PREVIOUSMONTH, SAMEPERIODLASTYEAR ou TOTALYTD.<\/li><\/ul>\n\n\n\n<p>Consultez notre section sur les fonctions DAX. Elle contient des articles expliquant, par exemple <strong><a href=\"https:\/\/expert-only.com\/power-bi\/calculer-la-valeur-du-mois-precedent-avec-dax-et-power-bi\/\">comment calculer la valeur du mois pr\u00e9c\u00e9dent avec DAX et Power BI<\/a><\/strong>. Ou encore des agr\u00e9gations \u00e0 l&rsquo;aide de formules et d&rsquo;exemples simples.<\/p>\n\n\n\n<p>Consultez \u00e9galement la section sur les articles des mod\u00e8les OLAP <strong><a href=\"https:\/\/expert-only.com\/ssas\/masquer-organiser-indicateurs-ssas-dossiers\/\">SSAS<\/a><\/strong>.<\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>DAX signifie Data Analysis Expressions, c&rsquo;est le langage de Microsoft pour manipuler les donn\u00e9es dans les cubes Microsoft SSAS Tabular ainsi que dans Power BI, et aussi dans Excel PowerPivot. La biblioth\u00e8que DAX est une biblioth\u00e8que Microsoft puissante et <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/concepts\/dax-signifie-data-analysis-expressions\/\" title=\"DAX signifie Data Analysis Expressions\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":{"0":"post-6891","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-concepts"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v26.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>DAX signifie Data Analysis Expressions - Concepts IT<\/title>\n<meta name=\"description\" content=\"DAX en informatique signifie Data Analysis Expressions, c&#039;est un langage Microsoft pour manipuler les donn\u00e9es dans les cubes et Power BI.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/expert-only.com\/fr\/concepts\/dax-signifie-data-analysis-expressions\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"DAX signifie Data Analysis Expressions\" \/>\n<meta property=\"og:description\" content=\"DAX en informatique signifie Data Analysis Expressions, c&#039;est un langage Microsoft pour manipuler les donn\u00e9es dans les cubes et Power BI.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/concepts\/dax-signifie-data-analysis-expressions\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutoriels SQL et IT\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-03-21T05:15:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-04-23T14:33:25+00:00\" \/>\n<meta name=\"author\" content=\"Expert-Only\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@expert_only\" \/>\n<meta name=\"twitter:site\" content=\"@expert_only\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/expert-only.com\/fr\/concepts\/dax-signifie-data-analysis-expressions\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/concepts\/dax-signifie-data-analysis-expressions\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"DAX signifie Data Analysis Expressions\",\"datePublished\":\"2022-03-21T05:15:00+00:00\",\"dateModified\":\"2022-04-23T14:33:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/concepts\/dax-signifie-data-analysis-expressions\/\"},\"wordCount\":300,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"articleSection\":[\"Concepts IT\"],\"inLanguage\":\"fr-FR\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/concepts\/dax-signifie-data-analysis-expressions\/\",\"url\":\"https:\/\/expert-only.com\/fr\/concepts\/dax-signifie-data-analysis-expressions\/\",\"name\":\"DAX signifie Data Analysis Expressions - Concepts IT\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"datePublished\":\"2022-03-21T05:15:00+00:00\",\"dateModified\":\"2022-04-23T14:33:25+00:00\",\"description\":\"DAX en informatique signifie Data Analysis Expressions, c'est un langage Microsoft pour manipuler les donn\u00e9es dans les cubes et Power BI.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/concepts\/dax-signifie-data-analysis-expressions\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/concepts\/dax-signifie-data-analysis-expressions\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/concepts\/dax-signifie-data-analysis-expressions\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"DAX signifie Data Analysis Expressions\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/fr\/#website\",\"url\":\"https:\/\/expert-only.com\/fr\/\",\"name\":\"Tutoriels SQL et IT\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/fr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"width\":381,\"height\":174,\"caption\":\"Expert-Only\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\",\"https:\/\/x.com\/expert_only\",\"https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"caption\":\"Expert-Only\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"DAX signifie Data Analysis Expressions - Concepts IT","description":"DAX en informatique signifie Data Analysis Expressions, c'est un langage Microsoft pour manipuler les donn\u00e9es dans les cubes et Power BI.","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:\/\/expert-only.com\/fr\/concepts\/dax-signifie-data-analysis-expressions\/","og_locale":"fr_FR","og_type":"article","og_title":"DAX signifie Data Analysis Expressions","og_description":"DAX en informatique signifie Data Analysis Expressions, c'est un langage Microsoft pour manipuler les donn\u00e9es dans les cubes et Power BI.","og_url":"https:\/\/expert-only.com\/fr\/concepts\/dax-signifie-data-analysis-expressions\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2022-03-21T05:15:00+00:00","article_modified_time":"2022-04-23T14:33:25+00:00","author":"Expert-Only","twitter_card":"summary_large_image","twitter_creator":"@expert_only","twitter_site":"@expert_only","twitter_misc":{"\u00c9crit par":"Expert-Only","Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/fr\/concepts\/dax-signifie-data-analysis-expressions\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/concepts\/dax-signifie-data-analysis-expressions\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"DAX signifie Data Analysis Expressions","datePublished":"2022-03-21T05:15:00+00:00","dateModified":"2022-04-23T14:33:25+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/concepts\/dax-signifie-data-analysis-expressions\/"},"wordCount":300,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"articleSection":["Concepts IT"],"inLanguage":"fr-FR"},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/concepts\/dax-signifie-data-analysis-expressions\/","url":"https:\/\/expert-only.com\/fr\/concepts\/dax-signifie-data-analysis-expressions\/","name":"DAX signifie Data Analysis Expressions - Concepts IT","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"datePublished":"2022-03-21T05:15:00+00:00","dateModified":"2022-04-23T14:33:25+00:00","description":"DAX en informatique signifie Data Analysis Expressions, c'est un langage Microsoft pour manipuler les donn\u00e9es dans les cubes et Power BI.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/concepts\/dax-signifie-data-analysis-expressions\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/concepts\/dax-signifie-data-analysis-expressions\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/concepts\/dax-signifie-data-analysis-expressions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"DAX signifie Data Analysis Expressions"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/fr\/#website","url":"https:\/\/expert-only.com\/fr\/","name":"Tutoriels SQL et IT","description":"","publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/fr\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","width":381,"height":174,"caption":"Expert-Only"},"image":{"@id":"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ExpertOnlyCom\/","https:\/\/x.com\/expert_only","https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA"]},{"@type":"Person","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","caption":"Expert-Only"}}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/6891","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/comments?post=6891"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/6891\/revisions"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=6891"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=6891"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=6891"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}