{"id":921,"date":"2019-07-28T07:35:10","date_gmt":"2019-07-28T07:35:10","guid":{"rendered":"http:\/\/blog.eticsolutions.ro\/?p=921"},"modified":"2020-01-20T06:58:58","modified_gmt":"2020-01-20T06:58:58","slug":"power-pivot-6-exemple-de-functii-dax-functia-switch","status":"publish","type":"post","link":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-6-exemple-de-functii-dax-functia-switch\/","title":{"rendered":"Power Pivot (6) &#8211; Exemple de Functii DAX. Functia SWITCH"},"content":{"rendered":"<p><span style=\"color: #800000;\"><strong><span style=\"color: #000000;\"><a href=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Cursuri_gratuite_Excel.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-841 alignleft\" src=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Cursuri_gratuite_Excel.png\" alt=\"Cursuri_gratuite_Excel\" width=\"113\" height=\"114\" srcset=\"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Cursuri_gratuite_Excel.png 176w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Cursuri_gratuite_Excel-150x152.png 150w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Cursuri_gratuite_Excel-100x101.png 100w\" sizes=\"auto, (max-width: 113px) 100vw, 113px\" \/><\/a>Incepand din 11 iulie 2016, vom publica in fiecare zi de luni si de joi cate un articol din seria de zece\u00a0cursuri gratuite dedicate Power Pivot pentru Excel 2013.<\/span><\/strong><\/span><\/p>\n<p><span style=\"color: #800000;\"><strong>ENJOY THE POWER! \ud83d\ude42<\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #800000;\"><strong><u>Exemplul 1<\/u><\/strong><\/span><\/p>\n<p>Se da un model de date, format din mai multe tabele relationate astfel:<\/p>\n<figure id=\"attachment_925\" aria-describedby=\"caption-attachment-925\" style=\"width: 533px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_6_Relationships.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-925\" src=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_6_Relationships.png\" alt=\"Power Pivot - Relatii intre tabele - Microsoft Excel 2013\" width=\"533\" height=\"353\" srcset=\"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_6_Relationships.png 533w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_6_Relationships-300x199.png 300w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_6_Relationships-100x66.png 100w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_6_Relationships-150x99.png 150w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_6_Relationships-200x132.png 200w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_6_Relationships-450x298.png 450w\" sizes=\"auto, (max-width: 533px) 100vw, 533px\" \/><\/a><figcaption id=\"caption-attachment-925\" class=\"wp-caption-text\"><strong>Power Pivot &#8211; Relatii intre tabele &#8211; Microsoft Excel 2013<\/strong><\/figcaption><\/figure>\n<p>In tabela <strong>tblOrders<\/strong>, avem nevoie de introducerea unei coloane calculate care sa arate luna efectuarii comenzii, in baza datei comenzii, asa cum apare ea in coloana <strong>Data comanda<\/strong>.<\/p>\n<p>Incarcam modelul de date (<strong>PowerPivot \u2013 Manage<\/strong>) si, in tabela <strong>tblOrders<\/strong> inseram o noua coloana (ea va fi denumita automat CalculatedColumn1), intre coloanele <strong>Data comanda<\/strong> si <strong>Status<\/strong>.<\/p>\n<figure id=\"attachment_924\" aria-describedby=\"caption-attachment-924\" style=\"width: 492px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_6_Insert-Calculated-Column-in-Data-Model.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-924\" src=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_6_Insert-Calculated-Column-in-Data-Model.png\" alt=\"Power Pivot - Inserare coloana calculata - Microsoft Excel 2013\" width=\"492\" height=\"746\" srcset=\"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_6_Insert-Calculated-Column-in-Data-Model.png 623w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_6_Insert-Calculated-Column-in-Data-Model-198x300.png 198w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_6_Insert-Calculated-Column-in-Data-Model-100x152.png 100w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_6_Insert-Calculated-Column-in-Data-Model-150x228.png 150w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_6_Insert-Calculated-Column-in-Data-Model-200x303.png 200w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_6_Insert-Calculated-Column-in-Data-Model-300x455.png 300w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_6_Insert-Calculated-Column-in-Data-Model-450x683.png 450w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_6_Insert-Calculated-Column-in-Data-Model-600x910.png 600w\" sizes=\"auto, (max-width: 492px) 100vw, 492px\" \/><\/a><figcaption id=\"caption-attachment-924\" class=\"wp-caption-text\"><strong>Power Pivot &#8211; Inserare coloana calculata &#8211; Microsoft Excel 2013<\/strong><\/figcaption><\/figure>\n<p>Pentru a afla luna efectuarii comenzii, utilizam functia <strong>MONTH<\/strong>, cu o sintaxa asemanatoare functiei clasice de tip <strong>Date&amp;Time<\/strong>.<\/p>\n<p><strong>=MONTH([Data comanda])<\/strong><\/p>\n<p>Aceasta functie va intoarce extrage luna din data calendaristica si va intoarce un rezultat numeric, de la 1 la 12.<\/p>\n<p>Ceea ce vrem sa obtinem, insa, este un rezultat de tip text, adica denumirea lunii in limba romana (Ianuarie, Februarie, etc.).<\/p>\n<p>Utilizand optiunile clasice furnizate de Excel 2013, avem doua variante:<\/p>\n<ul>\n<li>Utilizarea unei formule complexe, continand mai multe functii IF, de genul: =IF(MONTH([Data comanda])=1,\u201dIanuarie\u201d,IF(MONTH([Data comanda])=2,\u201dFebruarie\u201d,\u2026\u2026.)))..<\/li>\n<li>Utilizarea functiei VLOOKUP, cu conditia sa existe in fisierul Excel o tabela de corespondenta intre numar si denumire.<\/li>\n<\/ul>\n<p>Utilizand optiunile specifice furnizate de Power BI, vom alege functia SWITCH pentru a calcula denumirea lunii, in functie de indicativul de luna (1,2,\u2026..12).<\/p>\n<p><span style=\"color: #800000;\"><strong>Remember!<\/strong><\/span> Coloanele calculate <strong>NU<\/strong> exista in tabelele originale, ele vor putea fi utilizate in Pivot Table de tip Power Pivot.<\/p>\n<p>Functia SWITCH este o functie DAX de tip <strong>Logic<\/strong>, cu urmatoarea sintaxa:<\/p>\n<p><strong>=SWITCH(&lt;expression&gt;, &lt;value&gt;, &lt;result&gt;[, &lt;value&gt;, &lt;result&gt;]\u2026[, &lt;else&gt;])<\/strong><\/p>\n<p>Unde:<\/p>\n<p><strong>&lt;expression&gt;<\/strong> semnifica o interogare logica, asemanatoare cu <strong>logical_test<\/strong> al functiei clasice IF.<\/p>\n<p>In exemplul de mai sus, trebuie sa evaluam rezultatul functiei MONTH, aceasta putand avea valori de la 1 la 12.<\/p>\n<p>Daca <strong>&lt;value&gt;<\/strong> este 1, atunci <strong>&lt;result&gt;<\/strong> este textul \u201cIanuarie\u201d, daca <strong>&lt;value&gt;<\/strong> este 2, atunci <strong>&lt;result&gt;<\/strong> este textul \u201cFebruarie\u201d, \u2026.etc.<\/p>\n<p>Vom inscrie, prin urmare, formula:<\/p>\n<p><strong>=SWITCH(MONTH([Data comanda]),1,\u201dIanuarie\u201d,2,\u201dFebruarie\u201d,3,\u201dMartie\u201d,4,\u201dAprilie\u201d,5,\u201dMai\u201d,6,\u201dIunie\u201d,7,\u201dIulie\u201d,8,\u201dAugust\u201d,9,\u201dSeptembrie\u201d,10,\u201dOctombrie\u201d,11,\u201dNoiembrie\u201d,\u201dDecembrie\u201d)<\/strong><\/p>\n<p>Observati ca \u201cDecembrie\u201d corespunde argumentului <strong>&lt;else&gt;<\/strong>, pentru ca este ultima varianta posibila.<\/p>\n<p>Evident, pentru ca functia sa intoarca rezultatul corect, toate datele inscrise in coloana [Data comanda] trebuie sa fie de tip data calendaristica.<\/p>\n<figure id=\"attachment_923\" aria-describedby=\"caption-attachment-923\" style=\"width: 1199px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_6_Insert-Calculated-Column_Functia-SWITCH.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-923\" src=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_6_Insert-Calculated-Column_Functia-SWITCH.png\" alt=\"Power Pivot - Functia SWITCH - Microsoft Excel 2013\" width=\"1199\" height=\"183\" srcset=\"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_6_Insert-Calculated-Column_Functia-SWITCH.png 1199w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_6_Insert-Calculated-Column_Functia-SWITCH-300x46.png 300w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_6_Insert-Calculated-Column_Functia-SWITCH-768x117.png 768w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_6_Insert-Calculated-Column_Functia-SWITCH-1024x156.png 1024w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_6_Insert-Calculated-Column_Functia-SWITCH-100x15.png 100w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_6_Insert-Calculated-Column_Functia-SWITCH-150x23.png 150w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_6_Insert-Calculated-Column_Functia-SWITCH-200x31.png 200w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_6_Insert-Calculated-Column_Functia-SWITCH-450x69.png 450w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_6_Insert-Calculated-Column_Functia-SWITCH-600x92.png 600w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_6_Insert-Calculated-Column_Functia-SWITCH-900x137.png 900w\" sizes=\"auto, (max-width: 1199px) 100vw, 1199px\" \/><\/a><figcaption id=\"caption-attachment-923\" class=\"wp-caption-text\"><strong>Power Pivot &#8211; Functia SWITCH &#8211; Microsoft Excel 2013<\/strong><\/figcaption><\/figure>\n<p>Este o formula mult mai simpla si mai intuitiva decat utilizarea mai multor functii IF si inlocuieste cu succes functia VLOOKUP.<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #800000;\"><strong><u>Exemplul 2<\/u><\/strong><\/span><\/p>\n<p>In articolul <span style=\"color: #800000;\"><a style=\"color: #800000;\" href=\"http:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-5-exemple-de-functii-dax-functia-related\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>anterior<\/strong><\/a><\/span>, am invatat cum se utilizeaza functia <strong>RELATED<\/strong> (functie DAX de tip Filter) ca argument al functiei IF, pentru a calcula statusul unei facturi, intr-un model de date complex, care continea atat tabela <strong>facturi<\/strong>, cat si tabela <strong>FACT_RESTANTE<\/strong>, relationate prin coloana <strong>InvoiceID<\/strong>.<\/p>\n<p>Sa incercam sa obtinem acelasi rezultat, utilizand functia SWITCH, in loc de functia IF.<\/p>\n<p>Toate facturile restante se regasesc in tabela <strong>FACT_RESTANTE<\/strong>. In tabela <strong>facturi<\/strong>, vrem sa introducem o coloana calculata, denumita <strong>Status factura<\/strong>, care sa aiba valoarea <strong>platit<\/strong>, respectiv valoarea <strong>neplatit<\/strong>.<\/p>\n<p>Vom utiliza functia SWITCH, unde functia RELATED va fi parte a argumentului &lt;expression&gt;.<\/p>\n<p>ID-ul facturii este un numar. Daca interogarea cu functia RELATED intoarce un rezultat in tabela <strong>FACT_RESTANTE<\/strong>, acesta va fi chiar numarul facturii, prin urmare expresia RELATED(FACT_RESTANTE[InvoiceID]) va fi mai mare ca 0.<\/p>\n<p>In cazul in care rezultatul expresiei este pozitiv, inseamna ca este vorba despre o factura neplatita, in caz contrar (argumentul &lt;else&gt; al functiei SWITCH), este vorba despre o factura platita.<\/p>\n<p>Expresia <strong>RELATED(FACT_RESTANTE[InvoiceID])&gt;0<\/strong> intoarce un rezultat de tip <strong>logic<\/strong>, prin urmare argumentul <strong>&lt;value&gt;<\/strong> al functiei <strong>SWITCH<\/strong> trebuie sa fie tot o valoare logica.<\/p>\n<p>Formula<\/p>\n<p><strong>=SWITCH(RELATED(FACT_RESTANTE[InvoiceID])&gt;0,&#8221;TRUE&#8221;,&#8221;neplatit&#8221;,&#8221;platit&#8221;)<\/strong><\/p>\n<p>Intoarce <strong>eroare<\/strong>, pentru ca &lt;value&gt; este <strong>textul<\/strong> TRUE<strong>.<\/strong><\/p>\n<p>Utilizam functia<strong> TRUE()<\/strong>, care intoarce pur si simplu valoarea logica de adevar TRUE.<\/p>\n<p>Formula corecta va fi:<\/p>\n<p><strong>=SWITCH(RELATED(FACT_RESTANTE[InvoiceID])&gt;0,TRUE<\/strong><strong>()<\/strong><strong>,&#8221;neplatit&#8221;,&#8221;platit&#8221;<\/strong><strong>)<\/strong><\/p>\n<p>Am obtinut acelasi rezultat ca atunci cand am utilizat functia IF (coloana <strong>Status factura<\/strong>).<\/p>\n<figure id=\"attachment_922\" aria-describedby=\"caption-attachment-922\" style=\"width: 952px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_6_Insert-Calculated-Column_Functia-SWITCH-cu-ISNUMBER.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-922\" src=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_6_Insert-Calculated-Column_Functia-SWITCH-cu-ISNUMBER.png\" alt=\"Power Pivot - Variante de calcul SWITCH vs. IF - Microsoft Excel 2013\" width=\"952\" height=\"164\" srcset=\"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_6_Insert-Calculated-Column_Functia-SWITCH-cu-ISNUMBER.png 952w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_6_Insert-Calculated-Column_Functia-SWITCH-cu-ISNUMBER-300x52.png 300w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_6_Insert-Calculated-Column_Functia-SWITCH-cu-ISNUMBER-768x132.png 768w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_6_Insert-Calculated-Column_Functia-SWITCH-cu-ISNUMBER-100x17.png 100w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_6_Insert-Calculated-Column_Functia-SWITCH-cu-ISNUMBER-150x26.png 150w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_6_Insert-Calculated-Column_Functia-SWITCH-cu-ISNUMBER-200x34.png 200w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_6_Insert-Calculated-Column_Functia-SWITCH-cu-ISNUMBER-450x78.png 450w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_6_Insert-Calculated-Column_Functia-SWITCH-cu-ISNUMBER-600x103.png 600w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_6_Insert-Calculated-Column_Functia-SWITCH-cu-ISNUMBER-900x155.png 900w\" sizes=\"auto, (max-width: 952px) 100vw, 952px\" \/><\/a><figcaption id=\"caption-attachment-922\" class=\"wp-caption-text\"><strong>Power Pivot &#8211; Variante de calcul SWITCH vs. IF &#8211; Microsoft Excel 2013<\/strong><\/figcaption><\/figure>\n<p>In coloana <strong>CalculatedColumn1<\/strong>, am obtinut acelasi rezultat, utilizand o varianta a formulei de mai sus, prin introducerea functiei ISNUMBER.<\/p>\n<p><strong>=SWITCH(ISNUMBER(RELATED(FACT_RESTANTE[InvoiceID])),true(),&#8221;neplatit&#8221;,&#8221;platit&#8221;)<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Incepand din 11 iulie 2016, vom publica in fiecare zi de luni si de joi cate un articol din seria de zece\u00a0cursuri gratuite dedicate Power Pivot pentru Excel 2013. ENJOY THE POWER! \ud83d\ude42 &nbsp; Exemplul 1 Se da un model de date, format din mai multe tabele relationate astfel: In tabela tblOrders, avem nevoie de [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":841,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[171],"tags":[976,186,185,179,176,170,166,184],"class_list":["post-921","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-power-pivot","tag-cursuri-excel-online-gratuite","tag-functia-related","tag-functia-switch","tag-functii-dax","tag-model-de-date","tag-power-bi","tag-power-pivot","tag-relatii-tabele"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.9 - aioseo.com -->\n\t<meta name=\"description\" content=\"Incepand din 11 iulie 2016, vom publica in fiecare zi de luni si de joi cate un articol din seria de zece cursuri gratuite dedicate Power Pivot pentru Excel 2013. ENJOY THE POWER! :) Exemplul 1 Se da un model de date, format din mai multe tabele relationate astfel: In tabela tblOrders, avem nevoie de\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-6-exemple-de-functii-dax-functia-switch\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.9\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"-\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Power Pivot (6) \u2013 Exemple de Functii DAX. Functia SWITCH -\" \/>\n\t\t<meta property=\"og:description\" content=\"Incepand din 11 iulie 2016, vom publica in fiecare zi de luni si de joi cate un articol din seria de zece cursuri gratuite dedicate Power Pivot pentru Excel 2013. ENJOY THE POWER! :) Exemplul 1 Se da un model de date, format din mai multe tabele relationate astfel: In tabela tblOrders, avem nevoie de\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-6-exemple-de-functii-dax-functia-switch\/\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2015\/03\/SIGLA-BUNA-150x150.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2015\/03\/SIGLA-BUNA-150x150.jpg\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2019-07-28T07:35:10+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-01-20T06:58:58+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Power Pivot (6) \u2013 Exemple de Functii DAX. Functia SWITCH -\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Incepand din 11 iulie 2016, vom publica in fiecare zi de luni si de joi cate un articol din seria de zece cursuri gratuite dedicate Power Pivot pentru Excel 2013. ENJOY THE POWER! :) Exemplul 1 Se da un model de date, format din mai multe tabele relationate astfel: In tabela tblOrders, avem nevoie de\" \/>\n\t\t<meta name=\"twitter:image\" content=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2015\/03\/SIGLA-BUNA-150x150.jpg\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/power-pivot\\\/power-pivot-6-exemple-de-functii-dax-functia-switch\\\/#blogposting\",\"name\":\"Power Pivot (6) \\u2013 Exemple de Functii DAX. Functia SWITCH -\",\"headline\":\"Power Pivot (6) &#8211; Exemple de Functii DAX. Functia SWITCH\",\"author\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/author\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/#organization\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/07\\\/Cursuri_gratuite_Excel.png\",\"width\":176,\"height\":178},\"datePublished\":\"2019-07-28T07:35:10+00:00\",\"dateModified\":\"2020-01-20T06:58:58+00:00\",\"inLanguage\":\"en-US\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/power-pivot\\\/power-pivot-6-exemple-de-functii-dax-functia-switch\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/power-pivot\\\/power-pivot-6-exemple-de-functii-dax-functia-switch\\\/#webpage\"},\"articleSection\":\"Power Pivot, cursuri excel online gratuite, functia RELATED, functia SWITCH, functii DAX, model de date, Power BI, Power Pivot, relatii tabele\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/power-pivot\\\/power-pivot-6-exemple-de-functii-dax-functia-switch\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/category\\\/cursuri-excel\\\/#listItem\",\"name\":\"Cursuri Excel\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/category\\\/cursuri-excel\\\/#listItem\",\"position\":2,\"name\":\"Cursuri Excel\",\"item\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/category\\\/cursuri-excel\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/category\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/#listItem\",\"name\":\"Cursuri Excel gratuite\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/category\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/#listItem\",\"position\":3,\"name\":\"Cursuri Excel gratuite\",\"item\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/category\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/category\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/power-pivot\\\/#listItem\",\"name\":\"Power Pivot\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/category\\\/cursuri-excel\\\/#listItem\",\"name\":\"Cursuri Excel\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/category\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/power-pivot\\\/#listItem\",\"position\":4,\"name\":\"Power Pivot\",\"item\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/category\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/power-pivot\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/power-pivot\\\/power-pivot-6-exemple-de-functii-dax-functia-switch\\\/#listItem\",\"name\":\"Power Pivot (6) &#8211; Exemple de Functii DAX. Functia SWITCH\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/category\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/#listItem\",\"name\":\"Cursuri Excel gratuite\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/power-pivot\\\/power-pivot-6-exemple-de-functii-dax-functia-switch\\\/#listItem\",\"position\":5,\"name\":\"Power Pivot (6) &#8211; Exemple de Functii DAX. Functia SWITCH\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/category\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/power-pivot\\\/#listItem\",\"name\":\"Power Pivot\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/#organization\",\"url\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/wp-content\\\/uploads\\\/2015\\\/03\\\/SIGLA-BUNA-150x150.jpg\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/power-pivot\\\/power-pivot-6-exemple-de-functii-dax-functia-switch\\\/#organizationLogo\",\"width\":150,\"height\":150},\"image\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/power-pivot\\\/power-pivot-6-exemple-de-functii-dax-functia-switch\\\/#organizationLogo\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/author\\\/#author\",\"url\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/author\\\/\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/power-pivot\\\/power-pivot-6-exemple-de-functii-dax-functia-switch\\\/#webpage\",\"url\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/power-pivot\\\/power-pivot-6-exemple-de-functii-dax-functia-switch\\\/\",\"name\":\"Power Pivot (6) \\u2013 Exemple de Functii DAX. Functia SWITCH -\",\"description\":\"Incepand din 11 iulie 2016, vom publica in fiecare zi de luni si de joi cate un articol din seria de zece cursuri gratuite dedicate Power Pivot pentru Excel 2013. ENJOY THE POWER! :) Exemplul 1 Se da un model de date, format din mai multe tabele relationate astfel: In tabela tblOrders, avem nevoie de\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/power-pivot\\\/power-pivot-6-exemple-de-functii-dax-functia-switch\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/author\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/author\\\/#author\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/07\\\/Cursuri_gratuite_Excel.png\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/power-pivot\\\/power-pivot-6-exemple-de-functii-dax-functia-switch\\\/#mainImage\",\"width\":176,\"height\":178},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/power-pivot\\\/power-pivot-6-exemple-de-functii-dax-functia-switch\\\/#mainImage\"},\"datePublished\":\"2019-07-28T07:35:10+00:00\",\"dateModified\":\"2020-01-20T06:58:58+00:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Power Pivot (6) \u2013 Exemple de Functii DAX. Functia SWITCH -","description":"Incepand din 11 iulie 2016, vom publica in fiecare zi de luni si de joi cate un articol din seria de zece cursuri gratuite dedicate Power Pivot pentru Excel 2013. ENJOY THE POWER! :) Exemplul 1 Se da un model de date, format din mai multe tabele relationate astfel: In tabela tblOrders, avem nevoie de","canonical_url":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-6-exemple-de-functii-dax-functia-switch\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-6-exemple-de-functii-dax-functia-switch\/#blogposting","name":"Power Pivot (6) \u2013 Exemple de Functii DAX. Functia SWITCH -","headline":"Power Pivot (6) &#8211; Exemple de Functii DAX. Functia SWITCH","author":{"@id":"https:\/\/eticsolutions.ro\/blog\/author\/#author"},"publisher":{"@id":"https:\/\/eticsolutions.ro\/blog\/#organization"},"image":{"@type":"ImageObject","url":"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Cursuri_gratuite_Excel.png","width":176,"height":178},"datePublished":"2019-07-28T07:35:10+00:00","dateModified":"2020-01-20T06:58:58+00:00","inLanguage":"en-US","mainEntityOfPage":{"@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-6-exemple-de-functii-dax-functia-switch\/#webpage"},"isPartOf":{"@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-6-exemple-de-functii-dax-functia-switch\/#webpage"},"articleSection":"Power Pivot, cursuri excel online gratuite, functia RELATED, functia SWITCH, functii DAX, model de date, Power BI, Power Pivot, relatii tabele"},{"@type":"BreadcrumbList","@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-6-exemple-de-functii-dax-functia-switch\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog#listItem","position":1,"name":"Home","item":"https:\/\/eticsolutions.ro\/blog","nextItem":{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/#listItem","name":"Cursuri Excel"}},{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/#listItem","position":2,"name":"Cursuri Excel","item":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/","nextItem":{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/cursuri-excel-gratuite\/#listItem","name":"Cursuri Excel gratuite"},"previousItem":{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/cursuri-excel-gratuite\/#listItem","position":3,"name":"Cursuri Excel gratuite","item":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/cursuri-excel-gratuite\/","nextItem":{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/#listItem","name":"Power Pivot"},"previousItem":{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/#listItem","name":"Cursuri Excel"}},{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/#listItem","position":4,"name":"Power Pivot","item":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/","nextItem":{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-6-exemple-de-functii-dax-functia-switch\/#listItem","name":"Power Pivot (6) &#8211; Exemple de Functii DAX. Functia SWITCH"},"previousItem":{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/cursuri-excel-gratuite\/#listItem","name":"Cursuri Excel gratuite"}},{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-6-exemple-de-functii-dax-functia-switch\/#listItem","position":5,"name":"Power Pivot (6) &#8211; Exemple de Functii DAX. Functia SWITCH","previousItem":{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/#listItem","name":"Power Pivot"}}]},{"@type":"Organization","@id":"https:\/\/eticsolutions.ro\/blog\/#organization","url":"https:\/\/eticsolutions.ro\/blog\/","logo":{"@type":"ImageObject","url":"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2015\/03\/SIGLA-BUNA-150x150.jpg","@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-6-exemple-de-functii-dax-functia-switch\/#organizationLogo","width":150,"height":150},"image":{"@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-6-exemple-de-functii-dax-functia-switch\/#organizationLogo"}},{"@type":"Person","@id":"https:\/\/eticsolutions.ro\/blog\/author\/#author","url":"https:\/\/eticsolutions.ro\/blog\/author\/"},{"@type":"WebPage","@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-6-exemple-de-functii-dax-functia-switch\/#webpage","url":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-6-exemple-de-functii-dax-functia-switch\/","name":"Power Pivot (6) \u2013 Exemple de Functii DAX. Functia SWITCH -","description":"Incepand din 11 iulie 2016, vom publica in fiecare zi de luni si de joi cate un articol din seria de zece cursuri gratuite dedicate Power Pivot pentru Excel 2013. ENJOY THE POWER! :) Exemplul 1 Se da un model de date, format din mai multe tabele relationate astfel: In tabela tblOrders, avem nevoie de","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/eticsolutions.ro\/blog\/#website"},"breadcrumb":{"@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-6-exemple-de-functii-dax-functia-switch\/#breadcrumblist"},"author":{"@id":"https:\/\/eticsolutions.ro\/blog\/author\/#author"},"creator":{"@id":"https:\/\/eticsolutions.ro\/blog\/author\/#author"},"image":{"@type":"ImageObject","url":"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Cursuri_gratuite_Excel.png","@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-6-exemple-de-functii-dax-functia-switch\/#mainImage","width":176,"height":178},"primaryImageOfPage":{"@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-6-exemple-de-functii-dax-functia-switch\/#mainImage"},"datePublished":"2019-07-28T07:35:10+00:00","dateModified":"2020-01-20T06:58:58+00:00"},{"@type":"WebSite","@id":"https:\/\/eticsolutions.ro\/blog\/#website","url":"https:\/\/eticsolutions.ro\/blog\/","inLanguage":"en-US","publisher":{"@id":"https:\/\/eticsolutions.ro\/blog\/#organization"}}]},"og:locale":"en_US","og:site_name":"-","og:type":"article","og:title":"Power Pivot (6) \u2013 Exemple de Functii DAX. Functia SWITCH -","og:description":"Incepand din 11 iulie 2016, vom publica in fiecare zi de luni si de joi cate un articol din seria de zece cursuri gratuite dedicate Power Pivot pentru Excel 2013. ENJOY THE POWER! :) Exemplul 1 Se da un model de date, format din mai multe tabele relationate astfel: In tabela tblOrders, avem nevoie de","og:url":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-6-exemple-de-functii-dax-functia-switch\/","og:image":"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2015\/03\/SIGLA-BUNA-150x150.jpg","og:image:secure_url":"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2015\/03\/SIGLA-BUNA-150x150.jpg","article:published_time":"2019-07-28T07:35:10+00:00","article:modified_time":"2020-01-20T06:58:58+00:00","twitter:card":"summary_large_image","twitter:title":"Power Pivot (6) \u2013 Exemple de Functii DAX. Functia SWITCH -","twitter:description":"Incepand din 11 iulie 2016, vom publica in fiecare zi de luni si de joi cate un articol din seria de zece cursuri gratuite dedicate Power Pivot pentru Excel 2013. ENJOY THE POWER! :) Exemplul 1 Se da un model de date, format din mai multe tabele relationate astfel: In tabela tblOrders, avem nevoie de","twitter:image":"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2015\/03\/SIGLA-BUNA-150x150.jpg"},"aioseo_meta_data":{"post_id":"921","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_custom_url":null,"og_image_custom_fields":null,"og_image_url":null,"og_image_width":null,"og_image_height":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_image_url":null,"twitter_title":null,"twitter_description":null,"schema_type":"default","schema_type_options":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"limit_modified_date":false,"ai":null,"breadcrumb_settings":null,"seo_analyzer_scan_date":null,"created":"2026-06-29 09:51:21","updated":"2026-06-29 09:51:21"},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/eticsolutions.ro\/blog\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/\" title=\"Cursuri Excel\">Cursuri Excel<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/cursuri-excel-gratuite\/\" title=\"Cursuri Excel gratuite\">Cursuri Excel gratuite<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/\" title=\"Power Pivot\">Power Pivot<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tPower Pivot (6) \u2013 Exemple de Functii DAX. Functia SWITCH\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/eticsolutions.ro\/blog"},{"label":"Cursuri Excel","link":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/"},{"label":"Cursuri Excel gratuite","link":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/cursuri-excel-gratuite\/"},{"label":"Power Pivot","link":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/"},{"label":"Power Pivot (6) &#8211; Exemple de Functii DAX. Functia SWITCH","link":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-6-exemple-de-functii-dax-functia-switch\/"}],"_links":{"self":[{"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/posts\/921","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/comments?post=921"}],"version-history":[{"count":2,"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/posts\/921\/revisions"}],"predecessor-version":[{"id":3353,"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/posts\/921\/revisions\/3353"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/media\/841"}],"wp:attachment":[{"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/media?parent=921"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/categories?post=921"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/tags?post=921"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}