{"id":254,"date":"2020-12-23T18:32:00","date_gmt":"2020-12-23T14:32:00","guid":{"rendered":"https:\/\/dbformation.tech\/?p=254"},"modified":"2020-12-24T17:44:29","modified_gmt":"2020-12-24T13:44:29","slug":"power-pivot-ajouter-une-colonne-calculee","status":"publish","type":"post","link":"https:\/\/dbformation.tech\/2020\/12\/23\/power-pivot-ajouter-une-colonne-calculee\/","title":{"rendered":"Power Pivot : Ajouter une colonne calcul\u00e9e"},"content":{"rendered":"\n<p class=\"has-drop-cap wp-block-paragraph\">Cette vid\u00e9o  montre comment ins\u00e9rer une colonne calcul\u00e9e dans Power Pivot gr\u00e2ce \u00e0 une expression <strong>DAX<\/strong> (<strong>D<\/strong>ata <strong>A<\/strong>nalysis e<strong>X<\/strong>pression). Puis, dans un second temps, vous verrez comment ajouter ce champ \u00e0 un TCD.<\/p>\n\n\n\n<figure class=\"wp-block-video\"><video height=\"1020\" style=\"aspect-ratio: 1920 \/ 1020;\" width=\"1920\" controls src=\"https:\/\/dbformation.tech\/wp-content\/uploads\/2020\/12\/Powerpivot-Colonne-Fx-Calculee-1.m4v\"><\/video><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Pour reproduire ce que vous voyez \u00e0 l&rsquo;\u00e9cran, veuillez commencer par faire les tutoriels suivants :<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li><a href=\"https:\/\/dbformation.tech\/index.php\/2020\/12\/22\/excel-power-pivot-modeliser-des-donnees\/\" data-type=\"post\" data-id=\"223\">Power Pivot : Cr\u00e9er un mod\u00e8le de donn\u00e9es<\/a><\/li><li><a href=\"https:\/\/dbformation.tech\/index.php\/2020\/12\/23\/power-pivot-et-tableau-croise-dynamique\/\" data-type=\"post\" data-id=\"243\">Power Pivot et Tableau Crois\u00e9 Dynamique<\/a><\/li><\/ol>\n","protected":false},"excerpt":{"rendered":"<p>Cette vid\u00e9o montre comment ins\u00e9rer une colonne calcul\u00e9e dans Power Pivot gr\u00e2ce \u00e0 une expression DAX (Data Analysis eXpression). Puis, dans un second temps, vous verrez comment ajouter ce champ \u00e0 un TCD. Pour reproduire ce que vous voyez \u00e0 l&rsquo;\u00e9cran, veuillez commencer par faire les tutoriels suivants : Power Pivot : Cr\u00e9er un mod\u00e8le &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/dbformation.tech\/2020\/12\/23\/power-pivot-ajouter-une-colonne-calculee\/\" class=\"more-link\">Continuer la lecture<span class=\"screen-reader-text\"> de &laquo;&nbsp;Power Pivot : Ajouter une colonne calcul\u00e9e&nbsp;&raquo;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","footnotes":""},"categories":[22,5,30],"tags":[19,7,31,34],"class_list":["post-254","post","type-post","status-publish","format-standard","hentry","category-dax","category-excel","category-power-pivot-excel","tag-dax","tag-excel","tag-power-pivot","tag-video"],"_links":{"self":[{"href":"https:\/\/dbformation.tech\/wp-json\/wp\/v2\/posts\/254","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbformation.tech\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbformation.tech\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbformation.tech\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbformation.tech\/wp-json\/wp\/v2\/comments?post=254"}],"version-history":[{"count":9,"href":"https:\/\/dbformation.tech\/wp-json\/wp\/v2\/posts\/254\/revisions"}],"predecessor-version":[{"id":282,"href":"https:\/\/dbformation.tech\/wp-json\/wp\/v2\/posts\/254\/revisions\/282"}],"wp:attachment":[{"href":"https:\/\/dbformation.tech\/wp-json\/wp\/v2\/media?parent=254"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbformation.tech\/wp-json\/wp\/v2\/categories?post=254"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbformation.tech\/wp-json\/wp\/v2\/tags?post=254"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}