{"id":30543,"date":"2024-03-06T07:26:48","date_gmt":"2024-03-06T06:26:48","guid":{"rendered":"https:\/\/expert-only.com\/?p=30543"},"modified":"2024-03-06T21:31:24","modified_gmt":"2024-03-06T20:31:24","slug":"comment-calculer-la-valeur-du-mois-precedent-dans-power-bi","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/power-bi\/comment-calculer-la-valeur-du-mois-precedent-dans-power-bi\/","title":{"rendered":"Comment Calculer la Valeur du Mois Pr\u00e9c\u00e9dent dans Power BI ?"},"content":{"rendered":"\n<h4 class=\"wp-block-heading has-text-align-left\"><em>Comment cr\u00e9er un calcul de la valeur du mois pr\u00e9c\u00e9dent en utilisant les formules DAX dans Power BI ?<\/em><\/h4>\n\n\n\n<p>D\u00e9couvrez comment calculer la valeur du mois pr\u00e9c\u00e9dent dans Power BI dans ce tutoriel en utilisant 2 approches diff\u00e9rentes. Les gestionnaires, comptables, conseillers financiers et consultants en Business Intelligence utilisent beaucoup Power BI pour les comparaisons mensuelles, telles que les valeurs du mois pr\u00e9c\u00e9dent et de l&rsquo;ann\u00e9e derni\u00e8re. Pour cr\u00e9er ces mesures de comparaison, utilisez les fonctions d&rsquo;intelligence temporelle DAX disponibles dans l&rsquo;\u00e9diteur DAX. Utilisons la fonction DAX PREVIOUS MONTH pour cela.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-1-utiliser-la-fonction-dax-previousmonth-pour-calculer-le-mois-precedent\">1. Utiliser la fonction DAX PREVIOUSMONTH pour calculer le mois pr\u00e9c\u00e9dent<\/h2>\n\n\n\n<p>L&rsquo;objectif de la fonction DAX PREVIOUSMONTH est <strong>de r\u00e9cup\u00e9rer des donn\u00e9es du mois imm\u00e9diatement pr\u00e9c\u00e9dent bas\u00e9 sur une colonne de date sp\u00e9cifi\u00e9e<\/strong>. Par exemple, si vous avez des donn\u00e9es de ventes et que vous souhaitez comparer les ventes de ce mois avec celles du mois dernier, vous pourriez utiliser <strong><em>PREVIOUSMONTH(&lsquo;Table'[Date])<\/em><\/strong> dans une mesure.<\/p>\n\n\n\n<p>Une fois appliqu\u00e9e, la fonction filtre les donn\u00e9es pour inclure uniquement les valeurs du mois imm\u00e9diatement pr\u00e9c\u00e9dant la date la plus r\u00e9cente dans la colonne. Il est vital de noter que <strong>la fonction fonctionne dans le contexte de votre mod\u00e8le de donn\u00e9es Power BI<\/strong>. En d&rsquo;autres termes, elle fonctionne au mieux lorsque vous avez une table de dates correcte li\u00e9e \u00e0 vos donn\u00e9es transactionnelles. Je recommande fortement de v\u00e9rifier la configuration de votre table marqu\u00e9e comme date.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-deux-options-disponibles-en-utilisant-les-formules-dax-pour-ce-calcul\">Deux options disponibles en utilisant les formules DAX pour ce calcul<\/h3>\n\n\n\n<p>Consid\u00e9rons la table des ventes avec les ventes stock\u00e9es par mois, par an et le num\u00e9ro du client. De plus, pour toute fonction d&rsquo;intelligence temporelle dans DAX, c&rsquo;est-\u00e0-dire dans Power BI ou dans un mod\u00e8le tabulaire, une colonne de date doit \u00eatre la r\u00e9f\u00e9rence. Consid\u00e9rons que vous avez ces deux colonnes disponibles dans votre mod\u00e8le de donn\u00e9es :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>La colonne Montant des Ventes stocke le nombre de ventes enregistr\u00e9es ce jour-l\u00e0. <\/li>\n\n\n\n<li>La colonne Cl\u00e9 de Temps Date est une date utilis\u00e9e comme cl\u00e9 pour les jointures Power BI.<\/li>\n<\/ul>\n\n\n\n<p>V\u00e9rifiez aussi la possibilit\u00e9 de stocker le total des ventes d&rsquo;un mois sur un jour unique. Comme le 31 janvier 2020 pour le mois de janvier par exemple. En effet, l&rsquo;objectif est d&rsquo;introduire une cl\u00e9 de date unique pour les fonctions DAX temporelles, pour permettre le calcul des ventes du mois pr\u00e9c\u00e9dent. Pour cr\u00e9er la mesure, utilisez la <a href=\"https:\/\/docs.microsoft.com\/en-us\/dax\/previousmonth-function-dax\" target=\"_blank\" rel=\"noreferrer noopener\">fonction DAX du mois pr\u00e9c\u00e9dent<\/a>, sa documentation officielle et sa syntaxe sont disponibles sur le site de Microsoft.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-un-prerequis-configurer-une-table-de-dates-pour-utiliser-les-fonctions-d-intelligence-temporelle-dans-power-bi\">Un pr\u00e9requis : configurer une Table de Dates pour utiliser les fonctions d&rsquo;intelligence temporelle dans Power BI<\/h3>\n\n\n\n<p>Pour utiliser efficacement les fonctions d&rsquo;intelligence temporelle dans Power BI, un pr\u00e9requis est la configuration d&rsquo;une Table de Dates. Cette table, comportant une <strong>plage continue de dates<\/strong>, est cruciale pour mener des analyses temporelles pr\u00e9cises, car elle permet \u00e0 Power BI d&rsquo;appliquer des calculs dynamiques sur diverses p\u00e9riodes, assurant la pr\u00e9cision et la coh\u00e9rence dans l&rsquo;\u00e9valuation des donn\u00e9es temporelles.<\/p>\n\n\n\n<p>Parfois, lors de la construction d&rsquo;un mod\u00e8le, l&rsquo;erreur suivante peut \u00eatre rencontr\u00e9e : <em>\u00ab\u00a0\u00c9chec de la r\u00e9solution du nom &lsquo;REVIOUSMONTH&rsquo;. Ce n&rsquo;est pas un nom de table, de variable ou de fonction valide.<\/em>\u00a0\u00bb Pour la corriger, v\u00e9rifiez bien la barre de formule et les erreurs soulign\u00e9es, il s&rsquo;agit g\u00e9n\u00e9ralement d&rsquo;erreurs de syntaxe, ou de parenth\u00e8ses manquantes, c&rsquo;est-\u00e0-dire des erreurs de d\u00e9veloppement classiques. Et les messages affich\u00e9s par Power BI sont explicites.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-2-calculer-la-valeur-du-mois-precedent-depuis-la-source-de-donnees-dans-power-bi\">2. Calculer la valeur du mois pr\u00e9c\u00e9dent depuis la source de donn\u00e9es dans Power BI<\/h2>\n\n\n\n<p>Dans ce premier exemple, utilisez <strong>Power BI Desktop<\/strong> et un fichier Power BI (extension pbix) pour mapper directement la colonne \u00e0 partir de la source de donn\u00e9es. Et dans le logiciel de d\u00e9veloppement <strong>Visual Studio<\/strong> pour un Mod\u00e8le Tabulaire utilisant SSAS.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">Sales Last Month = \nCALCULATE (\n    SUM ( sales[sales] ),\n    PREVIOUSMONTH ( 'time'[date_key]),\n    REMOVEFILTERS ( sales )\n)<\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"740\" height=\"540\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/07\/power-bi-last-month-value-dax-formula.jpg\" alt=\"Formule Power BI pour calculer la valeur du mois pr\u00e9c\u00e9dent en utilisant DAX\" class=\"wp-image-26588\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/07\/power-bi-last-month-value-dax-formula.jpg 740w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/07\/power-bi-last-month-value-dax-formula-300x219.jpg 300w\" sizes=\"auto, (max-width: 740px) 100vw, 740px\" \/><figcaption class=\"wp-element-caption\"><em>Formule Power BI pour calculer la valeur du mois pr\u00e9c\u00e9dent en utilisant DAX<\/em><\/figcaption><\/figure><\/div>\n\n\n<p>Et le r\u00e9sultat dans le rapport Power BI donne quelque chose comme ceci :<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"740\" height=\"640\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/07\/power-bi-last-month-value-report-result.jpg\" alt=\"Rapport Power BI montrant les ventes du dernier mois calcul\u00e9es en utilisant la fonction temporelle PREVIOUSMONTH\" class=\"wp-image-26592\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/07\/power-bi-last-month-value-report-result.jpg 740w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/07\/power-bi-last-month-value-report-result-300x259.jpg 300w\" sizes=\"auto, (max-width: 740px) 100vw, 740px\" \/><figcaption class=\"wp-element-caption\"><em>Rapport Power BI montrant les ventes du dernier mois calcul\u00e9es en utilisant la fonction temporelle PREVIOUSMONTH<\/em><\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"h-3-utiliser-2-formules-dax-pour-calculer-le-mois-precedent\">3. Utiliser 2 formules DAX pour calculer le mois pr\u00e9c\u00e9dent<\/h2>\n\n\n\n<p>Cette seconde approche est tr\u00e8s similaire \u00e0 la premi\u00e8re, mais elle utilise simplement une mesure d\u00e9j\u00e0 cr\u00e9\u00e9e. Elle se fait en deux \u00e9tapes et utilise deux calculs DAX au lieu d&rsquo;un. Par exemple, cr\u00e9ez les mesures des ventes du mois en cours avec cette formule DAX.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">Sales := SUM('sales'[SalesAmount])<\/pre>\n\n\n\n<p>Ensuite, cr\u00e9ez la mesure des ventes du dernier mois en utilisant cette seconde formule DAX ci-dessous :<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">Sales Last Month = \nCALCULATE (\n    sales[sales],\n    PREVIOUSMONTH ( 'time'[date_key]),\n    REMOVEFILTERS ( sales )\n)<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-a-propos-des-calculs-temporels-glissants-dans-power-bi\">A propos des calculs temporels glissants dans Power BI<\/h3>\n\n\n\n<p>Dans ce tutoriel Power BI, les deux exemples montrent \u00e0 quel point il est facile de calculer une valeur du mois pr\u00e9c\u00e9dent dans Power BI en utilisant la fonction temporelle DAX PREVIOUSMONTH. Dans ce tutoriel pr\u00e9c\u00e9dent sur les fonctions DAX, d\u00e9couvrez <a href=\"https:\/\/expert-only.com\/en\/power-bi\/calculate-ytd-value-in-power-bi\/\">comment cr\u00e9er un calcul YTD en utilisant DAX et Power BI<\/a>.<\/p>\n\n\n\n<figure class=\"wp-block-embed aligncenter is-type-wp-embed is-provider-tutoriels-sql-et-it wp-block-embed-tutoriels-sql-et-it\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"1APXEDPGwA\"><a href=\"https:\/\/expert-only.com\/en\/power-bi\/calculate-ytd-value-in-power-bi\/\">How to calculate a YTD value with Power BI?<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"\u00ab\u00a0How to calculate a YTD value with Power BI?\u00a0\u00bb &#8212; Tutoriels SQL et IT\" src=\"https:\/\/expert-only.com\/en\/power-bi\/calculate-ytd-value-in-power-bi\/embed\/#?secret=lTVD08jgf7#?secret=1APXEDPGwA\" data-secret=\"1APXEDPGwA\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Pour calculer la valeur du mois pr\u00e9c\u00e9dent dans Power BI, utilisez la fonction temporelle PREVIOUSMONTH dans une formule DAX. <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/power-bi\/comment-calculer-la-valeur-du-mois-precedent-dans-power-bi\/\" title=\"Comment Calculer la Valeur du Mois Pr\u00e9c\u00e9dent dans Power BI ?\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":26320,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[444],"tags":[],"class_list":{"0":"post-30543","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-power-bi"},"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>Comment Calculer la Valeur du Mois Pr\u00e9c\u00e9dent dans Power BI ?<\/title>\n<meta name=\"description\" content=\"Pour calculer la valeur du mois pr\u00e9c\u00e9dent dans Power BI, utiliser la fonction temporelle PREVIOUSMONTH dans une formule 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:\/\/expert-only.com\/fr\/power-bi\/comment-calculer-la-valeur-du-mois-precedent-dans-power-bi\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Comment Calculer la Valeur du Mois Pr\u00e9c\u00e9dent dans Power BI ?\" \/>\n<meta property=\"og:description\" content=\"Pour calculer la valeur du mois pr\u00e9c\u00e9dent dans Power BI, utiliser la fonction temporelle PREVIOUSMONTH dans une formule DAX.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/power-bi\/comment-calculer-la-valeur-du-mois-precedent-dans-power-bi\/\" \/>\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=\"2024-03-06T06:26:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-06T20:31:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/03\/new-york-g80e1b732a_1920_1080.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\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=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/expert-only.com\/fr\/power-bi\/comment-calculer-la-valeur-du-mois-precedent-dans-power-bi\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/power-bi\/comment-calculer-la-valeur-du-mois-precedent-dans-power-bi\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Comment Calculer la Valeur du Mois Pr\u00e9c\u00e9dent dans Power BI ?\",\"datePublished\":\"2024-03-06T06:26:48+00:00\",\"dateModified\":\"2024-03-06T20:31:24+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/power-bi\/comment-calculer-la-valeur-du-mois-precedent-dans-power-bi\/\"},\"wordCount\":906,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/power-bi\/comment-calculer-la-valeur-du-mois-precedent-dans-power-bi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/03\/new-york-g80e1b732a_1920_1080.jpg\",\"articleSection\":[\"Power BI\"],\"inLanguage\":\"fr-FR\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/power-bi\/comment-calculer-la-valeur-du-mois-precedent-dans-power-bi\/\",\"url\":\"https:\/\/expert-only.com\/fr\/power-bi\/comment-calculer-la-valeur-du-mois-precedent-dans-power-bi\/\",\"name\":\"Comment Calculer la Valeur du Mois Pr\u00e9c\u00e9dent dans Power BI ?\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/power-bi\/comment-calculer-la-valeur-du-mois-precedent-dans-power-bi\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/power-bi\/comment-calculer-la-valeur-du-mois-precedent-dans-power-bi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/03\/new-york-g80e1b732a_1920_1080.jpg\",\"datePublished\":\"2024-03-06T06:26:48+00:00\",\"dateModified\":\"2024-03-06T20:31:24+00:00\",\"description\":\"Pour calculer la valeur du mois pr\u00e9c\u00e9dent dans Power BI, utiliser la fonction temporelle PREVIOUSMONTH dans une formule DAX.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/power-bi\/comment-calculer-la-valeur-du-mois-precedent-dans-power-bi\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/power-bi\/comment-calculer-la-valeur-du-mois-precedent-dans-power-bi\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/power-bi\/comment-calculer-la-valeur-du-mois-precedent-dans-power-bi\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/03\/new-york-g80e1b732a_1920_1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/03\/new-york-g80e1b732a_1920_1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/power-bi\/comment-calculer-la-valeur-du-mois-precedent-dans-power-bi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Comment Calculer la Valeur du Mois Pr\u00e9c\u00e9dent dans Power BI ?\"}]},{\"@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":"Comment Calculer la Valeur du Mois Pr\u00e9c\u00e9dent dans Power BI ?","description":"Pour calculer la valeur du mois pr\u00e9c\u00e9dent dans Power BI, utiliser la fonction temporelle PREVIOUSMONTH dans une formule 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:\/\/expert-only.com\/fr\/power-bi\/comment-calculer-la-valeur-du-mois-precedent-dans-power-bi\/","og_locale":"fr_FR","og_type":"article","og_title":"Comment Calculer la Valeur du Mois Pr\u00e9c\u00e9dent dans Power BI ?","og_description":"Pour calculer la valeur du mois pr\u00e9c\u00e9dent dans Power BI, utiliser la fonction temporelle PREVIOUSMONTH dans une formule DAX.","og_url":"https:\/\/expert-only.com\/fr\/power-bi\/comment-calculer-la-valeur-du-mois-precedent-dans-power-bi\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2024-03-06T06:26:48+00:00","article_modified_time":"2024-03-06T20:31:24+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/03\/new-york-g80e1b732a_1920_1080.jpg","type":"image\/jpeg"}],"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":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/fr\/power-bi\/comment-calculer-la-valeur-du-mois-precedent-dans-power-bi\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/power-bi\/comment-calculer-la-valeur-du-mois-precedent-dans-power-bi\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Comment Calculer la Valeur du Mois Pr\u00e9c\u00e9dent dans Power BI ?","datePublished":"2024-03-06T06:26:48+00:00","dateModified":"2024-03-06T20:31:24+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/power-bi\/comment-calculer-la-valeur-du-mois-precedent-dans-power-bi\/"},"wordCount":906,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/power-bi\/comment-calculer-la-valeur-du-mois-precedent-dans-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/03\/new-york-g80e1b732a_1920_1080.jpg","articleSection":["Power BI"],"inLanguage":"fr-FR"},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/power-bi\/comment-calculer-la-valeur-du-mois-precedent-dans-power-bi\/","url":"https:\/\/expert-only.com\/fr\/power-bi\/comment-calculer-la-valeur-du-mois-precedent-dans-power-bi\/","name":"Comment Calculer la Valeur du Mois Pr\u00e9c\u00e9dent dans Power BI ?","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/power-bi\/comment-calculer-la-valeur-du-mois-precedent-dans-power-bi\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/power-bi\/comment-calculer-la-valeur-du-mois-precedent-dans-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/03\/new-york-g80e1b732a_1920_1080.jpg","datePublished":"2024-03-06T06:26:48+00:00","dateModified":"2024-03-06T20:31:24+00:00","description":"Pour calculer la valeur du mois pr\u00e9c\u00e9dent dans Power BI, utiliser la fonction temporelle PREVIOUSMONTH dans une formule DAX.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/power-bi\/comment-calculer-la-valeur-du-mois-precedent-dans-power-bi\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/power-bi\/comment-calculer-la-valeur-du-mois-precedent-dans-power-bi\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/power-bi\/comment-calculer-la-valeur-du-mois-precedent-dans-power-bi\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/03\/new-york-g80e1b732a_1920_1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/03\/new-york-g80e1b732a_1920_1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/power-bi\/comment-calculer-la-valeur-du-mois-precedent-dans-power-bi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Comment Calculer la Valeur du Mois Pr\u00e9c\u00e9dent dans Power BI ?"}]},{"@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\/30543","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=30543"}],"version-history":[{"count":4,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/30543\/revisions"}],"predecessor-version":[{"id":30555,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/30543\/revisions\/30555"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media\/26320"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=30543"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=30543"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=30543"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}