{"id":195172,"date":"2023-04-20T18:29:00","date_gmt":"2023-04-20T18:29:00","guid":{"rendered":"https:\/\/datascientest.com\/?p=195172"},"modified":"2023-11-09T13:30:19","modified_gmt":"2023-11-09T13:30:19","slug":"power-query-m-switch-tout-savoir","status":"publish","type":"post","link":"https:\/\/datascientest.com\/power-query-m-switch-tout-savoir","title":{"rendered":"Power Query M Switch : Comment fonctionne cet outil ?"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"195172\" class=\"elementor elementor-195172\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-8f7c074 e-flex e-con-boxed e-con\" data-id=\"8f7c074\" 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-bcfcb11 elementor-widget elementor-widget-heading\" data-id=\"bcfcb11\" 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\">Le M Switch de Power Query simplifie la gestion des expressions conditionnelles et all\u00e8ge les formules de transformation de donn\u00e9es complexes. D\u00e9couvrez tout ce que vous devez savoir !<\/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-14fc522 e-flex e-con-boxed e-con\" data-id=\"14fc522\" 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-8f88cd2 elementor-widget elementor-widget-text-editor\" data-id=\"8f88cd2\" 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;\">Sur <a href=\"https:\/\/datascientest.com\/power-query-excel-tout-savoir\">Microsoft Excel<\/a> et <a href=\"https:\/\/datascientest.com\/power-bi-pour-les-nuls\">Power BI<\/a>, l\u2019outil Power Query offre de nombreuses possibilit\u00e9s. Son \u00e9diteur de requ\u00eates simple et intuitif permet de <strong>collecter des donn\u00e9es<\/strong> en provenance de multiples sources, de les transformer et de les charger dans un tableau.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Outre les fonctions accessibles en un seul clic depuis l\u2019interface graphique, le <strong>langage de programmation M<\/strong> permet de r\u00e9diger des formules personnalis\u00e9es pour des transformations plus complexes ou sp\u00e9cifiques.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Toutefois, les formules M peuvent devenir trop lourdes et compliqu\u00e9es lorsqu\u2019il faut g\u00e9rer des cas multiples ou des expressions conditionnelles complexes. Afin d\u2019\u00e9viter ce probl\u00e8me, on peut utiliser le <strong>M Switch<\/strong>.<\/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-2b011fb e-flex e-con-boxed e-con\" data-id=\"2b011fb\" 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-fa41142 elementor-widget elementor-widget-heading\" data-id=\"fa41142\" 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\">Comprendre les expressions conditionnelles en M<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ce5e1c4 elementor-widget elementor-widget-text-editor\" data-id=\"ce5e1c4\" 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;\">Les expressions conditionnelles en langage M permettent de <strong>d\u00e9finir des conditions pour transformer les donn\u00e9es<\/strong>. Elles servent notamment \u00e0 effectuer des op\u00e9rations comme la suppression de lignes, la modification de valeurs ou la fusion de colonnes.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Les conditions sont g\u00e9n\u00e9ralement bas\u00e9es sur des comparaisons, des \u00e9valuations de valeur et des tests logiques. La structure basique d\u2019une expression conditionnelle en M est la suivante :\u00a0<\/span><\/p><blockquote><pre><span style=\"font-weight: 400;\">\u00ab if [condition] then [value_if_true] else [value_if_false] \u00bb<\/span><\/pre><\/blockquote><p><span style=\"font-weight: 400;\">Afin d\u2019effectuer des tests multiples, il est possible d\u2019<strong>imbriquer plusieurs expressions conditionnelles<\/strong>. Pour \u00e9viter une syntaxe trop lourde, il est pr\u00e9f\u00e9rable d\u2019utiliser le M Switch.<\/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-76900f5 e-flex e-con-boxed e-con\" data-id=\"76900f5\" 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-691870b elementor-widget elementor-widget-heading\" data-id=\"691870b\" 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\">Qu\u2019est-ce que le M Switch ? <\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0e3b150 elementor-widget elementor-widget-text-editor\" data-id=\"0e3b150\" 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;\">Dans les langages de programmation, une fonction Switch permet d\u2019<strong>\u00e9valuer une expression ou une variable<\/strong> et d\u2019<strong>ex\u00e9cuter un bloc de code<\/strong> en fonction de sa valeur.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">On l\u2019utilise souvent pour simplifier les expressions conditionnelles complexes, et pour \u00e9viter les structures de contr\u00f4les imbriqu\u00e9es telles que les <strong>boucles if\/else<\/strong>.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Elle permet de sp\u00e9cifier une liste de cas ou de valeurs possible pour une expression donn\u00e9e, puis de fournir une action ou un bloc de code \u00e0 ex\u00e9cuter pour chaque cas.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">De nombreux langages de programmation ont une fonction Switch, notamment <strong>JavaScript<\/strong>, <a href=\"https:\/\/datascientest.com\/formation-langage-python\">Python<\/a>, <strong>C#<\/strong> et <strong>Visual Basic<\/strong>.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">C\u2019est \u00e9galement le cas du <strong>langage de formules M<\/strong> incorpor\u00e9 \u00e0 Power Query pour Microsoft Excel et Power BI. <\/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-7bb5ef6 e-flex e-con-boxed e-con\" data-id=\"7bb5ef6\" 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-6f5ff92 elementor-widget elementor-widget-heading\" data-id=\"6f5ff92\" 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\">\u00c0 quoi \u00e7a sert ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-36b3995 elementor-widget elementor-widget-text-editor\" data-id=\"36b3995\" 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;\">Le M Switch de Power Query permet de <strong>s\u00e9lectionner des actions sp\u00e9cifiques<\/strong> \u00e0 effectuer en fonction des valeurs d\u2019une colonne de tableau ou d\u2019une autre condition.<\/span><\/p><p><span style=\"font-weight: 400;\">Il s\u2019agit d\u2019un outil de transformation conditionnelle servant \u00e0 <strong>effectuer des op\u00e9rations sur des valeurs sp\u00e9cifiques<\/strong>. L\u2019utilisateur peut sp\u00e9cifier des valeurs \u00e0 rechercher et des op\u00e9rations \u00e0 effectuer pour chaque valeur trouv\u00e9e.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">C\u2019est particuli\u00e8rement utile pour le <strong>traitement de donn\u00e9es<\/strong> lorsqu\u2019il est n\u00e9cessaire de g\u00e9rer plusieurs cas conditionnels, puisqu\u2019il permet de les organiser en une seule formule facile \u00e0 lire et \u00e0 comprendre.<\/span><\/p><p><span style=\"font-weight: 400;\">De m\u00eame, M Switch permet de remplacer l\u2019imbrication excessive de fonctions comme les <strong>clauses if\/then<\/strong> pouvant rendre la formule difficile \u00e0 lire et \u00e0 maintenir.<\/span><\/p><p><span style=\"font-weight: 400;\">Enfin, cet outil est tr\u00e8s pratique pour effectuer des transformations de donn\u00e9es avanc\u00e9es sur des donn\u00e9es complexes.<\/span><\/p><p><span style=\"font-weight: 400;\">En r\u00e9sum\u00e9, le M Switch <strong>att\u00e9nue la complexit\u00e9 des formules<\/strong>, <strong>facilite leur maintenance et leur modification<\/strong>, et <strong>r\u00e9duit le risque d\u2019erreurs<\/strong> telles que des oublis de valeur ou l\u2019utilisation d\u2019une op\u00e9ration logique incorrecte.\u00a0<\/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-3ed79cf elementor-widget elementor-widget-image\" data-id=\"3ed79cf\" 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=\"1500\" height=\"950\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/4865921-programmeur-people-concept-use-laptop-and-programming-code-program-icon-spreading-with-modern-flat-style-gratuit-vectoriel.jpg\" class=\"attachment-full size-full wp-image-195207\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/4865921-programmeur-people-concept-use-laptop-and-programming-code-program-icon-spreading-with-modern-flat-style-gratuit-vectoriel.jpg 1500w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/4865921-programmeur-people-concept-use-laptop-and-programming-code-program-icon-spreading-with-modern-flat-style-gratuit-vectoriel-300x190.jpg 300w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/4865921-programmeur-people-concept-use-laptop-and-programming-code-program-icon-spreading-with-modern-flat-style-gratuit-vectoriel-1024x649.jpg 1024w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/4865921-programmeur-people-concept-use-laptop-and-programming-code-program-icon-spreading-with-modern-flat-style-gratuit-vectoriel-768x486.jpg 768w\" sizes=\"(max-width: 1500px) 100vw, 1500px\" \/>\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-1bd2a32 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"1bd2a32\" 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-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/formation-power-bi\">\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\">D\u00e9marrer une formation Power Query<\/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-f27fc1c e-flex e-con-boxed e-con\" data-id=\"f27fc1c\" 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-604c947 elementor-widget elementor-widget-heading\" data-id=\"604c947\" 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\">Comment fonctionne le M Switch ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-808c380 elementor-widget elementor-widget-text-editor\" data-id=\"808c380\" 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;\">Le <strong>fonctionnement du M Switch<\/strong> repose sur l\u2019\u00e9valuation d\u2019une s\u00e9rie d\u2019expressions conditionnelles jusqu\u2019\u00e0 ce qu\u2019une condition soit vraie. D\u00e8s que la condition est vraie, Switch retourne la valeur correspondante ou ex\u00e9cute l\u2019action associ\u00e9e \u00e0 cette condition.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Sa syntaxe est la suivante : <\/span><\/p><blockquote><pre><span style=\"font-weight: 400;\">\u00ab M Switch(expression, {valeur1, r\u00e9sultat1}, {valeur2, r\u00e9sultat2}, ..., {valeurN, r\u00e9sultatN}, [default]) \u00bb<\/span><\/pre><\/blockquote><p><span style=\"font-weight: 400;\">L\u2019argument \u00ab expression \u00bb est l\u2019expression ou la variable \u00e0 \u00e9valuer, tandis que les arguments \u00ab valeur1 \u00bb, \u00ab valeur2 \u00bb, \u00ab valeurN \u00bb sont <strong>les valeurs possibles de l\u2019expression \u00e0 \u00e9valuer<\/strong>.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">De leur c\u00f4t\u00e9, les arguments \u00ab r\u00e9sultat1 \u00bb, \u00ab r\u00e9sultat2 \u00bb, \u00ab r\u00e9sutlatN \u00bb sont <strong>les r\u00e9sultats \u00e0 retourner<\/strong> si l\u2019expression \u00e9valu\u00e9e correspond \u00e0 la valeur correspondante.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Enfin, \u00ab default \u00bb est <strong>un argument optionnel<\/strong> sp\u00e9cifiant la valeur \u00e0 retourner si l\u2019expression \u00e9valu\u00e9e ne correspond \u00e0 aucune des valeurs sp\u00e9cifi\u00e9es dans la liste.<\/span><\/p><p><span style=\"font-weight: 400;\">Voici un exemple d\u2019utilisation du M Switch de Power Query pour cr\u00e9er une colonne calcul\u00e9e en fonction de la valeur d\u2019une autre colonne :\u00a0\u00a0<\/span><\/p><blockquote><pre><span style=\"font-weight: 400;\">\u00ab let<\/span><\/pre><p><span style=\"font-weight: 400;\">\u00a0\u00a0\u00a0\u00a0Source = Table.FromRecords({<\/span><\/p><p><span style=\"font-weight: 400;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0[Fruit=\u00a0\u00bbPomme\u00a0\u00bb, Prix=2.0],<\/span><\/p><p><span style=\"font-weight: 400;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0[Fruit=\u00a0\u00bbBanane\u00a0\u00bb, Prix=1.5],<\/span><\/p><p><span style=\"font-weight: 400;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0[Fruit=\u00a0\u00bbOrange\u00a0\u00bb, Prix=2.5]<\/span><\/p><p><span style=\"font-weight: 400;\">\u00a0\u00a0\u00a0\u00a0}),<\/span><\/p><p><span style=\"font-weight: 400;\">\u00a0\u00a0\u00a0\u00a0#\u00a0\u00bbAjouter une colonne calcul\u00e9e\u00a0\u00bb = Table.AddColumn(Source, \u00ab\u00a0Cat\u00e9gorie\u00a0\u00bb, each\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0M Switch([Fruit],\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0{\u00ab\u00a0Pomme\u00a0\u00bb, \u00ab\u00a0Orange\u00a0\u00bb}, \u00ab\u00a0Fruit commun\u00a0\u00bb,<\/span><\/p><p><span style=\"font-weight: 400;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0{\u00ab\u00a0Banane\u00a0\u00bb}, \u00ab\u00a0Fruit exotique\u00a0\u00bb,<\/span><\/p><p><span style=\"font-weight: 400;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0[Fruit]<\/span><\/p><p><span style=\"font-weight: 400;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0)<\/span><\/p><p><span style=\"font-weight: 400;\">\u00a0\u00a0\u00a0\u00a0)<\/span><\/p><p><span style=\"font-weight: 400;\">in<\/span><\/p><p><span style=\"font-weight: 400;\">\u00a0\u00a0\u00a0\u00a0#\u00a0\u00bbAjouter une colonne calcul\u00e9e\u00a0\u00bb \u00bb<\/span><\/p><\/blockquote><p><span style=\"font-weight: 400;\">Dans cet exemple, une colonne calcul\u00e9e appel\u00e9e \u00ab Cat\u00e9gorie \u00bb a \u00e9t\u00e9 ajout\u00e9e en utilisant le M Switch pour attribuer une cat\u00e9gorie \u00e0 chaque fruit en fonction de sa valeur.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Si le fruit est une pomme ou une orange, la valeur de la colonne \u00ab Cat\u00e9gorie \u00bb sera \u00ab Fruit commun \u00bb. S\u2019il s\u2019agit d\u2019une pomme ou d\u2019une orange, la valeur sera \u00ab Fruit exotique \u00bb. Enfin, si le fruit n\u2019est ni une pomme, ni une orange, ni une banane, la valeur de la colonne sera \u00e9gale \u00e0 celle de la colonne \u00ab Fruit \u00bb.<\/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-a024198 e-flex e-con-boxed e-con\" data-id=\"a024198\" 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-ed98317 elementor-widget elementor-widget-heading\" data-id=\"ed98317\" 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\">Conclusion : Power Query M Switch, une alternative solide \u00e0 l\u2019imbrication if\/then<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-67db580 elementor-widget elementor-widget-text-editor\" data-id=\"67db580\" 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;\">Vous l\u2019aurez compris : le M Switch de Power Query est d\u2019un pr\u00e9cieux secours pour simplifier les formules complexes avec des expressions conditionnelles et des clauses <strong>if\/then<\/strong> imbriqu\u00e9es.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">C\u2019est l\u2019une des nombreuses possibilit\u00e9s offertes par Power Query dont beaucoup de n\u00e9ophytes ignorent l\u2019existence. Afin de <strong>ma\u00eetriser pleinement cet outil<\/strong> et d\u2019exploiter tout son potentiel, vous pouvez choisir <strong>DataScientest<\/strong>.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">En seulement <strong>5 jours<\/strong>, notre <strong>formation Power BI<\/strong> vous permet d\u2019apprendre \u00e0 collecter, transformer et analyser les donn\u00e9es et \u00e0 produire des tableaux de bord interactifs.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Au fil des diff\u00e9rents modules, vous d\u00e9couvrirez Power Query et le langage M, les fonctionnalit\u00e9s de <a href=\"https:\/\/datascientest.com\/quest-ce-la-dataviz-le-point-avec-nos-data-experts\">DataViz<\/a> ou encore les concepts plus avanc\u00e9s comme les <strong>DataFlows<\/strong> et l\u2019<strong>actualisation incr\u00e9mentielle<\/strong>.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">A la fin du cursus, DataScientest vous accompagne dans le passage de l\u2019<strong>examen Microsoft PL-300<\/strong> permettant d\u2019obtenir la <a href=\"https:\/\/datascientest.com\/pl-300-tout-savoir\">certification Power BI Data Analyst Associate<\/a>.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Tous nos programmes se compl\u00e8tent int\u00e9gralement en ligne, et sont \u00e9ligibles au <a href=\"https:\/\/datascientest.com\/cpf-comment-utiliser-son-compte-personnel-de-formation\">Compte Personnel de Formation<\/a> pour le financement. <strong>D\u00e9couvrez vite DataScientest !<\/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-13144be elementor-widget elementor-widget-image\" data-id=\"13144be\" 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=\"1066\" height=\"531\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/datascientest.jpg\" class=\"attachment-full size-full wp-image-195211\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/datascientest.jpg 1066w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/datascientest-300x149.jpg 300w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/datascientest-1024x510.jpg 1024w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/datascientest-768x383.jpg 768w\" sizes=\"(max-width: 1066px) 100vw, 1066px\" \/>\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-5bd2ac3 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"5bd2ac3\" 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-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/formation-power-bi\">\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\">D\u00e9marrer une formation Power BI <\/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<div class=\"elementor-element elementor-element-01d2691 elementor-widget elementor-widget-text-editor\" data-id=\"01d2691\" 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;\">Vous savez tout sur le M Switch de Power Query. Pour plus d\u2019informations sur le m\u00eame sujet, d\u00e9couvrez <a href=\"https:\/\/datascientest.com\/power-query-tout-savoir\">notre guide complet sur Power Query<\/a> et <a href=\"https:\/\/datascientest.com\/power-bi\">notre dossier consacr\u00e9 \u00e0 Power BI<\/a>.\u00a0<\/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-09fa79e e-flex e-con-boxed e-con\" data-id=\"09fa79e\" 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-4166d9a elementor-widget elementor-widget-html\" data-id=\"4166d9a\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<script type=\"application\/ld+json\">\r\n{\r\n  \"@context\": \"https:\/\/schema.org\",\r\n  \"@type\": \"FAQPage\",\r\n  \"mainEntity\": [{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Qu\u2019est-ce que le M Switch ? \",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Dans les langages de programmation, une fonction Switch permet d\u2019\u00e9valuer une expression ou une variable et d\u2019ex\u00e9cuter un bloc de code en fonction de sa valeur. On l\u2019utilise souvent pour simplifier les expressions conditionnelles complexes, et pour \u00e9viter les structures de contr\u00f4les imbriqu\u00e9es telles que les boucles if\/else.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"\u00c0 quoi \u00e7a sert ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Le M Switch de Power Query permet de s\u00e9lectionner des actions sp\u00e9cifiques \u00e0 effectuer en fonction des valeurs d\u2019une colonne de tableau ou d\u2019une autre condition. Il s\u2019agit d\u2019un outil de transformation conditionnelle servant \u00e0 effectuer des op\u00e9rations sur des valeurs sp\u00e9cifiques. L\u2019utilisateur peut sp\u00e9cifier des valeurs \u00e0 rechercher et des op\u00e9rations \u00e0 effectuer pour chaque valeur trouv\u00e9e.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Comment fonctionne le M Switch ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Le fonctionnement du M Switch repose sur l\u2019\u00e9valuation d\u2019une s\u00e9rie d\u2019expressions conditionnelles jusqu\u2019\u00e0 ce qu\u2019une condition soit vraie. D\u00e8s que la condition est vraie, Switch retourne la valeur correspondante ou ex\u00e9cute l\u2019action associ\u00e9e \u00e0 cette condition.\"\r\n    }\r\n  }]\r\n}\r\n<\/script>\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>Le M Switch de Power Query simplifie la gestion des expressions conditionnelles et all\u00e8ge les formules de transformation de donn\u00e9es complexes. D\u00e9couvrez tout ce que vous devez savoir ! Sur Microsoft Excel et Power BI, l\u2019outil Power Query offre de nombreuses possibilit\u00e9s. Son \u00e9diteur de requ\u00eates simple et intuitif permet de collecter des donn\u00e9es en [&hellip;]<\/p>\n","protected":false},"author":74,"featured_media":195198,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2493],"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>Power Query M Switch : Comment fonctionne cet outil ?<\/title>\n<meta name=\"description\" content=\"Le M Switch de Power Query simplifie la gestion des expressions conditionnelles et all\u00e8ge les formules de transformation de donn\u00e9es complexes.\" \/>\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\/power-query-m-switch-tout-savoir\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Power Query M Switch : Comment fonctionne cet outil ?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/power-query-m-switch-tout-savoir\" \/>\n<meta property=\"og:site_name\" content=\"Formation Data Science | DataScientest.com\" \/>\n<meta property=\"article:published_time\" content=\"2023-04-20T18:29:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-09T13:30:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/m-switch-power-query.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Antoine Tardivon\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Antoine Tardivon\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/power-query-m-switch-tout-savoir\",\"url\":\"https:\/\/datascientest.com\/power-query-m-switch-tout-savoir\",\"name\":\"Power Query M Switch : Comment fonctionne cet outil ?\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/#website\"},\"datePublished\":\"2023-04-20T18:29:00+00:00\",\"dateModified\":\"2023-11-09T13:30:19+00:00\",\"author\":{\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57\"},\"description\":\"Le M Switch de Power Query simplifie la gestion des expressions conditionnelles et all\u00e8ge les formules de transformation de donn\u00e9es complexes.\",\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/power-query-m-switch-tout-savoir\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/#website\",\"url\":\"https:\/\/datascientest.com\/\",\"name\":\"Formation Data Science | DataScientest.com\",\"description\":\"Leader de la formation en Data Science\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57\",\"name\":\"Antoine Tardivon\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg\",\"contentUrl\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg\",\"caption\":\"Antoine Tardivon\"},\"description\":\"Antoine Tardivon est Data Scientist chez DataScientest. Il a pr\u00e9c\u00e9demment effectu\u00e9 un stage en impl\u00e9mentation Python \u00e0 l'University of Helsinki et en recherche Machine Learning chez Thales. Dipl\u00f4m\u00e9 de l'Ecole centrale de Nantes et d'Audencia, il poss\u00e8de des comp\u00e9tences en ing\u00e9nierie et en finance.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/antoine-tardivon-385881204\/\",\"Business Intelligence\"],\"url\":\"https:\/\/datascientest.com\/author\/antoinetardivon\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Power Query M Switch : Comment fonctionne cet outil ?","description":"Le M Switch de Power Query simplifie la gestion des expressions conditionnelles et all\u00e8ge les formules de transformation de donn\u00e9es complexes.","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\/power-query-m-switch-tout-savoir","og_locale":"fr_FR","og_type":"article","og_title":"Power Query M Switch : Comment fonctionne cet outil ?","og_url":"https:\/\/datascientest.com\/power-query-m-switch-tout-savoir","og_site_name":"Formation Data Science | DataScientest.com","article_published_time":"2023-04-20T18:29:00+00:00","article_modified_time":"2023-11-09T13:30:19+00:00","og_image":[{"width":1200,"height":600,"url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/m-switch-power-query.png","type":"image\/png"}],"author":"Antoine Tardivon","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Antoine Tardivon","Dur\u00e9e de lecture estim\u00e9e":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/datascientest.com\/power-query-m-switch-tout-savoir","url":"https:\/\/datascientest.com\/power-query-m-switch-tout-savoir","name":"Power Query M Switch : Comment fonctionne cet outil ?","isPartOf":{"@id":"https:\/\/datascientest.com\/#website"},"datePublished":"2023-04-20T18:29:00+00:00","dateModified":"2023-11-09T13:30:19+00:00","author":{"@id":"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57"},"description":"Le M Switch de Power Query simplifie la gestion des expressions conditionnelles et all\u00e8ge les formules de transformation de donn\u00e9es complexes.","inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/power-query-m-switch-tout-savoir"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/#website","url":"https:\/\/datascientest.com\/","name":"Formation Data Science | DataScientest.com","description":"Leader de la formation en Data Science","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57","name":"Antoine Tardivon","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/datascientest.com\/#\/schema\/person\/image\/","url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg","contentUrl":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg","caption":"Antoine Tardivon"},"description":"Antoine Tardivon est Data Scientist chez DataScientest. Il a pr\u00e9c\u00e9demment effectu\u00e9 un stage en impl\u00e9mentation Python \u00e0 l'University of Helsinki et en recherche Machine Learning chez Thales. Dipl\u00f4m\u00e9 de l'Ecole centrale de Nantes et d'Audencia, il poss\u00e8de des comp\u00e9tences en ing\u00e9nierie et en finance.","sameAs":["https:\/\/www.linkedin.com\/in\/antoine-tardivon-385881204\/","Business Intelligence"],"url":"https:\/\/datascientest.com\/author\/antoinetardivon"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/195172"}],"collection":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/users\/74"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/comments?post=195172"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/195172\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media\/195198"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media?parent=195172"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/categories?post=195172"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/tags?post=195172"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}