{"id":936,"date":"2019-08-01T06:17:18","date_gmt":"2019-08-01T06:17:18","guid":{"rendered":"http:\/\/blog.eticsolutions.ro\/?p=936"},"modified":"2020-01-20T06:58:40","modified_gmt":"2020-01-20T06:58:40","slug":"power-pivot-7-exemple-de-functii-dax-functia-calculate","status":"publish","type":"post","link":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-7-exemple-de-functii-dax-functia-calculate\/","title":{"rendered":"Power Pivot (7) &#8211; Exemple de Functii DAX. Functia CALCULATE"},"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>Se da un Pivot Table de tip Power Pivot, construit in baza unui <strong><span style=\"color: #800000;\"><a style=\"color: #800000; text-decoration: underline;\" href=\"http:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-cum-se-construieste-un-model-de-date\/\" target=\"_blank\" rel=\"noopener noreferrer\">model de date<\/a><\/span><\/strong> format din mai multe <strong><span style=\"color: #800000;\"><a style=\"color: #800000;\" href=\"http:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-cum-se-realizeza-legatura-intre-tabele\/\" target=\"_blank\" rel=\"noopener noreferrer\">tabele relationate<\/a><\/span><\/strong> astfel:<\/p>\n<figure id=\"attachment_935\" aria-describedby=\"caption-attachment-935\" style=\"width: 533px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Relationships-between-tables.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-935\" src=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Relationships-between-tables.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_7_Relationships-between-tables.png 533w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Relationships-between-tables-300x199.png 300w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Relationships-between-tables-100x66.png 100w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Relationships-between-tables-150x99.png 150w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Relationships-between-tables-200x132.png 200w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Relationships-between-tables-450x298.png 450w\" sizes=\"auto, (max-width: 533px) 100vw, 533px\" \/><\/a><figcaption id=\"caption-attachment-935\" class=\"wp-caption-text\"><strong>Power Pivot &#8211; Relatii intre tabele &#8211; Microsoft Excel 2013<\/strong><\/figcaption><\/figure>\n<p>In Pivot Table, vrem sa introducem un camp calculat (<strong>Calculated field<\/strong>) care sa calculeze sintetic rata de incasare. Cu alte cuvinte, vrem sa calculam o asa-numita <strong>masura<\/strong>, care sa calculeze un indice de tipul: total valoare facturi platite\/total valoare facturi.<\/p>\n<p>Deocamdata, construim un pivot simplu, care contine urmatoarele campuri:<\/p>\n<ul>\n<li>ROWS &#8211; <strong>Activity type<\/strong> (coloana din tabela <strong>contracte<\/strong>!)<\/li>\n<li>COLUMNS &#8211; <strong>Status factura<\/strong> (coloana calculata din tabela <strong>facturi<\/strong>), in baza relatiei definite intre tabela <strong>facturi<\/strong> si tabela <strong>FACT_RESTANTE<\/strong><\/li>\n<li>VALUES \u2013Invoice value[EUR] (coloana calculata din tabela <strong>facturi<\/strong>), in baza relatiei definite intre tabela <strong>facturi<\/strong> si tabela <strong>curs_lunar<\/strong><\/li>\n<\/ul>\n<p>Coloana <strong>Status factura <\/strong>(vezi <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>aici<\/strong><\/a><\/span> cum am realizat aceasta coloana calculata) contine una dintre valorile: <strong>platit<\/strong>, <strong>neplatit<\/strong>.<\/p>\n<figure id=\"attachment_934\" aria-describedby=\"caption-attachment-934\" style=\"width: 1185px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Pivot-Table-sinteza-categorie-si-an-facturare.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-934\" src=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Pivot-Table-sinteza-categorie-si-an-facturare.png\" alt=\"Power Pivot - Pivot Table - Microsoft Excel 2013\" width=\"1185\" height=\"620\" srcset=\"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Pivot-Table-sinteza-categorie-si-an-facturare.png 1185w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Pivot-Table-sinteza-categorie-si-an-facturare-300x157.png 300w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Pivot-Table-sinteza-categorie-si-an-facturare-768x402.png 768w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Pivot-Table-sinteza-categorie-si-an-facturare-1024x536.png 1024w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Pivot-Table-sinteza-categorie-si-an-facturare-100x52.png 100w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Pivot-Table-sinteza-categorie-si-an-facturare-150x78.png 150w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Pivot-Table-sinteza-categorie-si-an-facturare-200x105.png 200w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Pivot-Table-sinteza-categorie-si-an-facturare-450x235.png 450w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Pivot-Table-sinteza-categorie-si-an-facturare-600x314.png 600w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Pivot-Table-sinteza-categorie-si-an-facturare-900x471.png 900w\" sizes=\"auto, (max-width: 1185px) 100vw, 1185px\" \/><\/a><figcaption id=\"caption-attachment-934\" class=\"wp-caption-text\"><strong>Power Pivot &#8211; Pivot Table &#8211; Microsoft Excel 2013<\/strong><\/figcaption><\/figure>\n<p>Ceea ce vrem noi sa calculam, inseamna practic sa impartim totalul aferent statusului <strong>platit<\/strong> la totalul general pe rand (<strong>Grand Total<\/strong>).<\/p>\n<p>Mai mult decat atat, am vrea sa realizam un Pivot Table de tip Power Pivot care sa arate pe coloane si anii de facturare, astfel incat, pe fiecare activitate (sau alt tip de sinteza, pe clienti, de exemplu), sa vedem defalcat rata de incasare, pe fiecare an de facturare.<\/p>\n<p>Vom utiliza functia <strong>CALCULATE<\/strong>, o functie DAX de tip Filter, o categorie speciala de functii care nu se regaseste in setul de functii disponibile in varianta clasica de Excel.<\/p>\n<p>Sintaxa functiei CALCULATE este:<\/p>\n<p><strong>=CALCULATE(Expression, [Filter1],[Filter2],\u2026)<\/strong>, unde<\/p>\n<p><strong>Expression<\/strong> \u2013 expresia care trebuie evaluata (calculata)<\/p>\n<p><strong>Filter1,filter2<\/strong>,\u2026 &#8211; argument optional; expresii de tip Boolean sau de tip tabel, care definesc un filtru.<\/p>\n<p>Functia <strong>CALCULATE<\/strong> nu poate fi utilizata in cadrul unui model de date decat sub forma unei expresii sintetice de tip <strong>Calculated Field<\/strong>. Cu alte cuvinte, spre deosebire de functia RELATED sau functia SWITCH, nu poate fi utilizata pentru a introduce in tabelele relationate din model noi coloana calculate.<\/p>\n<p>Campurile calculate realizate in cadrul Power BI apar doar in Pivot Table si, spre deosebire de campurile calculate disponibile in Pivot Table clasic, functiile utilizate la calcularea lor pot utiliza ca argumente coloane (sau alte campuri calculate) din oricare din tabelele relationate din modelul de date.<\/p>\n<p>Pentru a insera un <strong>camp calculat de utilizator<\/strong>, apasati butonul <strong>Calculated Field<\/strong> din meniul <strong>PowerPivot<\/strong> si alegeti optiunea <strong>New Calculated Field<\/strong>.<\/p>\n<p>Daca vreti sa modificati un camp calculat anterior, alegeti optiunea <strong>Manage Calculated Fields<\/strong>.<\/p>\n<figure id=\"attachment_933\" aria-describedby=\"caption-attachment-933\" style=\"width: 886px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Insert-Calculated-Field.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-933\" src=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Insert-Calculated-Field.png\" alt=\"Power Pivot - Insert Calculated Field - Microsoft Excel 2013\" width=\"886\" height=\"125\" srcset=\"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Insert-Calculated-Field.png 886w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Insert-Calculated-Field-300x42.png 300w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Insert-Calculated-Field-768x108.png 768w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Insert-Calculated-Field-100x14.png 100w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Insert-Calculated-Field-150x21.png 150w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Insert-Calculated-Field-200x28.png 200w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Insert-Calculated-Field-450x63.png 450w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Insert-Calculated-Field-600x85.png 600w\" sizes=\"auto, (max-width: 886px) 100vw, 886px\" \/><\/a><figcaption id=\"caption-attachment-933\" class=\"wp-caption-text\"><strong>Power Pivot &#8211; Insert Calculated Field &#8211; Microsoft Excel 2013<\/strong><\/figcaption><\/figure>\n<p>Va aparea urmatoarea fereastra de dialog:<\/p>\n<figure id=\"attachment_932\" aria-describedby=\"caption-attachment-932\" style=\"width: 614px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Calculated-Field-window.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-932\" src=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Calculated-Field-window.png\" alt=\"Power Pivot - Fereastra de dialog Calculated Field - Microsoft Excel 2013\" width=\"614\" height=\"439\" srcset=\"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Calculated-Field-window.png 614w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Calculated-Field-window-300x214.png 300w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Calculated-Field-window-100x71.png 100w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Calculated-Field-window-150x107.png 150w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Calculated-Field-window-200x143.png 200w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Calculated-Field-window-450x322.png 450w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Calculated-Field-window-600x429.png 600w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/a><figcaption id=\"caption-attachment-932\" class=\"wp-caption-text\"><strong>Power Pivot &#8211; Fereastra de dialog Calculated Field &#8211; Microsoft Excel 2013<\/strong><\/figcaption><\/figure>\n<p>Modificati denumirea predefinita <strong>Calculated field 1 \u2026..<\/strong>, pentru a putea regasi mai usor campurile calculate realizate. Am dat denumirea <strong>%platit<\/strong> noului camp calculat de utilizator.<\/p>\n<p>Introducem deocamdata in rubrica urmatoarea formula:<\/p>\n<p><strong>=<\/strong><strong>CALCULATE<\/strong><strong>([Sum of Invoice valueEUR],facturi[Status factura]=&#8221;platit&#8221;)<\/strong><\/p>\n<p><strong><a href=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/semn-exclamare.gif\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-837 alignleft\" src=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/semn-exclamare.gif\" alt=\"semn exclamare\" width=\"30\" height=\"45\" \/><\/a>CALCULATE<\/strong> reprezinta un fel de<strong> super-SUMIF<\/strong>, care realizeaza calcule sintetice pentru Pivot Tables de tip Power Pivot.<\/p>\n<p>Formula de mai sus realizeaza o sinteza (recalculata automat in functie de coloana pe care o alegem in rubrica ROWS a Pivot Table) a valorii facturilor in euro, tinand cont de urmatoarea conditie: statusul facturii sa fie textul \u201cplatit\u201d. Cu alte cuvinte, formula de mai sus va realiza un calcul sintetic al sumei totale a facturilor platite.<\/p>\n<figure id=\"attachment_931\" aria-describedby=\"caption-attachment-931\" style=\"width: 614px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Calculated-Field-window2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-931\" src=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Calculated-Field-window2.png\" alt=\"Power Pivot - Fereastra de dialog Calculated Field - Microsoft Excel 2013\" width=\"614\" height=\"541\" srcset=\"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Calculated-Field-window2.png 614w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Calculated-Field-window2-300x264.png 300w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Calculated-Field-window2-100x88.png 100w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Calculated-Field-window2-150x132.png 150w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Calculated-Field-window2-200x176.png 200w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Calculated-Field-window2-450x396.png 450w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Calculated-Field-window2-600x529.png 600w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/a><figcaption id=\"caption-attachment-931\" class=\"wp-caption-text\"><strong>Power Pivot &#8211; Fereastra de dialog Calculated Field &#8211; Microsoft Excel 2013<\/strong><\/figcaption><\/figure>\n<p>Pentru a verifica corectitudinea formulei, apasati butonul <strong>Check formula<\/strong>.<\/p>\n<p>Formatati rezultatul. In exemplul de mai sus, am ales o reprezentare cu 2 zecimale si fara separator de mii.<\/p>\n<figure id=\"attachment_930\" aria-describedby=\"caption-attachment-930\" style=\"width: 1122px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Pivot-Table-sinteza-categorie-si-valoare-incasari.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-930\" src=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Pivot-Table-sinteza-categorie-si-valoare-incasari.png\" alt=\"Power Pivot -Pivot Table intermediar - Microsoft Excel 2013\" width=\"1122\" height=\"614\" srcset=\"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Pivot-Table-sinteza-categorie-si-valoare-incasari.png 1122w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Pivot-Table-sinteza-categorie-si-valoare-incasari-300x164.png 300w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Pivot-Table-sinteza-categorie-si-valoare-incasari-768x420.png 768w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Pivot-Table-sinteza-categorie-si-valoare-incasari-1024x560.png 1024w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Pivot-Table-sinteza-categorie-si-valoare-incasari-100x55.png 100w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Pivot-Table-sinteza-categorie-si-valoare-incasari-150x82.png 150w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Pivot-Table-sinteza-categorie-si-valoare-incasari-200x109.png 200w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Pivot-Table-sinteza-categorie-si-valoare-incasari-450x246.png 450w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Pivot-Table-sinteza-categorie-si-valoare-incasari-600x328.png 600w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Pivot-Table-sinteza-categorie-si-valoare-incasari-900x493.png 900w\" sizes=\"auto, (max-width: 1122px) 100vw, 1122px\" \/><\/a><figcaption id=\"caption-attachment-930\" class=\"wp-caption-text\"><strong>Power Pivot -Pivot Table intermediar &#8211; Microsoft Excel 2013<\/strong><\/figcaption><\/figure>\n<p>Deocamdata am realizat calculul valorii totale a facturilor platite.<\/p>\n<p>Pentru a obtine rezultatul de care aveam nevoie, formula anterioara trebuie completata prin impartirea la suma totala a facturilor.<\/p>\n<p>Formula finala va fi:<\/p>\n<p><strong>=CALCULATE([Sum of Invoice valueEUR],facturi[Status factura]=&#8221;platit&#8221;)\/[Sum of Invoice valueEUR]<\/strong><\/p>\n<p>Alternativ, puteam utiliza si urmatoarea formula:<\/p>\n<p><strong>=CALCULATE(sum([Invoice value[EUR]]])<\/strong><strong>,facturi[Status factura]=&#8221;platit&#8221;)\/[Sum of Invoice valueEUR]<\/strong>, in care argumentul Expression este rezultatul functiei SUM aplicat pentru coloana calculata [Invoice value[EUR]]].<\/p>\n<p><strong><span style=\"color: #800000;\">Gata!<\/span><\/strong><\/p>\n<p>In Pivot Table, introduceti si coloana <strong>YearID <\/strong>pe coloane.<\/p>\n<p>Raportul sintetic va arata acum astfel:<\/p>\n<figure id=\"attachment_929\" aria-describedby=\"caption-attachment-929\" style=\"width: 1159px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Pivot-Table-sinteza-categorie-si-an-facturare_platit.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-929\" src=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Pivot-Table-sinteza-categorie-si-an-facturare_platit.png\" alt=\"Power Pivot - Pivot Table ce contine un camp calculat de utilizator - Microsoft Excel 2013\" width=\"1159\" height=\"598\" srcset=\"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Pivot-Table-sinteza-categorie-si-an-facturare_platit.png 1159w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Pivot-Table-sinteza-categorie-si-an-facturare_platit-300x155.png 300w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Pivot-Table-sinteza-categorie-si-an-facturare_platit-768x396.png 768w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Pivot-Table-sinteza-categorie-si-an-facturare_platit-1024x528.png 1024w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Pivot-Table-sinteza-categorie-si-an-facturare_platit-100x52.png 100w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Pivot-Table-sinteza-categorie-si-an-facturare_platit-150x77.png 150w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Pivot-Table-sinteza-categorie-si-an-facturare_platit-200x103.png 200w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Pivot-Table-sinteza-categorie-si-an-facturare_platit-450x232.png 450w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Pivot-Table-sinteza-categorie-si-an-facturare_platit-600x310.png 600w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_7_Pivot-Table-sinteza-categorie-si-an-facturare_platit-900x464.png 900w\" sizes=\"auto, (max-width: 1159px) 100vw, 1159px\" \/><\/a><figcaption id=\"caption-attachment-929\" class=\"wp-caption-text\"><strong>Power Pivot &#8211; Pivot Table ce contine un camp calculat de utilizator &#8211; Microsoft Excel 2013<\/strong><\/figcaption><\/figure>\n<p>In sinteza de mai sus, pentru categoria <strong>Inspectii<\/strong>, de exemplu, rezultatul se citeste astfel:<\/p>\n<ul>\n<li>Nu au fost facturari in anii 2013 si 2014<\/li>\n<li>In anul 2015, s-a incasat 98.65% din valoarea totala a facturilor emise in <strong>2015<\/strong> pentru categoria <strong>Inspectii<\/strong><\/li>\n<li>In anul 2016, s-a incasat 87.45% din valoarea totala a facturilor emise in <strong>2016<\/strong> pentru categoria <strong>Inspectii<\/strong><\/li>\n<li>Valoarea totala a incasarilor pentru categoria <strong>Inspectii<\/strong>, pentru intreaga perioada de analiza, este de 97.26 din totalul facturarilor pe aceasta categorie<\/li>\n<\/ul>\n<p>In articolul urmator, vom exemplifica si alte modalitati de utilizare a functiei <strong>CALCULATE<\/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; Se da un Pivot Table de tip Power Pivot, construit in baza unui model de date format din mai multe tabele [&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":[189,976,188,179,176,170,166,187],"class_list":["post-936","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-power-pivot","tag-calculated-field","tag-cursuri-excel-online-gratuite","tag-functia-calculate","tag-functii-dax","tag-model-de-date","tag-power-bi","tag-power-pivot","tag-relatii-intre-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! :) Se da un Pivot Table de tip Power Pivot, construit in baza unui model de date format din mai multe tabele\" \/>\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-7-exemple-de-functii-dax-functia-calculate\/\" \/>\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 (7) \u2013 Exemple de Functii DAX. Functia CALCULATE -\" \/>\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! :) Se da un Pivot Table de tip Power Pivot, construit in baza unui model de date format din mai multe tabele\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-7-exemple-de-functii-dax-functia-calculate\/\" \/>\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-08-01T06:17:18+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-01-20T06:58:40+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Power Pivot (7) \u2013 Exemple de Functii DAX. Functia CALCULATE -\" \/>\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! :) Se da un Pivot Table de tip Power Pivot, construit in baza unui model de date format din mai multe tabele\" \/>\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-7-exemple-de-functii-dax-functia-calculate\\\/#blogposting\",\"name\":\"Power Pivot (7) \\u2013 Exemple de Functii DAX. Functia CALCULATE -\",\"headline\":\"Power Pivot (7) &#8211; Exemple de Functii DAX. Functia CALCULATE\",\"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-08-01T06:17:18+00:00\",\"dateModified\":\"2020-01-20T06:58:40+00:00\",\"inLanguage\":\"en-US\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/power-pivot\\\/power-pivot-7-exemple-de-functii-dax-functia-calculate\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/power-pivot\\\/power-pivot-7-exemple-de-functii-dax-functia-calculate\\\/#webpage\"},\"articleSection\":\"Power Pivot, Calculated field, cursuri excel online gratuite, functia CALCULATE, functii DAX, model de date, Power BI, Power Pivot, relatii intre tabele\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/power-pivot\\\/power-pivot-7-exemple-de-functii-dax-functia-calculate\\\/#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-7-exemple-de-functii-dax-functia-calculate\\\/#listItem\",\"name\":\"Power Pivot (7) &#8211; Exemple de Functii DAX. Functia CALCULATE\"},\"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-7-exemple-de-functii-dax-functia-calculate\\\/#listItem\",\"position\":5,\"name\":\"Power Pivot (7) &#8211; Exemple de Functii DAX. Functia CALCULATE\",\"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-7-exemple-de-functii-dax-functia-calculate\\\/#organizationLogo\",\"width\":150,\"height\":150},\"image\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/power-pivot\\\/power-pivot-7-exemple-de-functii-dax-functia-calculate\\\/#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-7-exemple-de-functii-dax-functia-calculate\\\/#webpage\",\"url\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/power-pivot\\\/power-pivot-7-exemple-de-functii-dax-functia-calculate\\\/\",\"name\":\"Power Pivot (7) \\u2013 Exemple de Functii DAX. Functia CALCULATE -\",\"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! :) Se da un Pivot Table de tip Power Pivot, construit in baza unui model de date format din mai multe tabele\",\"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-7-exemple-de-functii-dax-functia-calculate\\\/#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-7-exemple-de-functii-dax-functia-calculate\\\/#mainImage\",\"width\":176,\"height\":178},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/power-pivot\\\/power-pivot-7-exemple-de-functii-dax-functia-calculate\\\/#mainImage\"},\"datePublished\":\"2019-08-01T06:17:18+00:00\",\"dateModified\":\"2020-01-20T06:58:40+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 (7) \u2013 Exemple de Functii DAX. Functia CALCULATE -","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! :) Se da un Pivot Table de tip Power Pivot, construit in baza unui model de date format din mai multe tabele","canonical_url":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-7-exemple-de-functii-dax-functia-calculate\/","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-7-exemple-de-functii-dax-functia-calculate\/#blogposting","name":"Power Pivot (7) \u2013 Exemple de Functii DAX. Functia CALCULATE -","headline":"Power Pivot (7) &#8211; Exemple de Functii DAX. Functia CALCULATE","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-08-01T06:17:18+00:00","dateModified":"2020-01-20T06:58:40+00:00","inLanguage":"en-US","mainEntityOfPage":{"@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-7-exemple-de-functii-dax-functia-calculate\/#webpage"},"isPartOf":{"@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-7-exemple-de-functii-dax-functia-calculate\/#webpage"},"articleSection":"Power Pivot, Calculated field, cursuri excel online gratuite, functia CALCULATE, functii DAX, model de date, Power BI, Power Pivot, relatii intre tabele"},{"@type":"BreadcrumbList","@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-7-exemple-de-functii-dax-functia-calculate\/#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-7-exemple-de-functii-dax-functia-calculate\/#listItem","name":"Power Pivot (7) &#8211; Exemple de Functii DAX. Functia CALCULATE"},"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-7-exemple-de-functii-dax-functia-calculate\/#listItem","position":5,"name":"Power Pivot (7) &#8211; Exemple de Functii DAX. Functia CALCULATE","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-7-exemple-de-functii-dax-functia-calculate\/#organizationLogo","width":150,"height":150},"image":{"@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-7-exemple-de-functii-dax-functia-calculate\/#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-7-exemple-de-functii-dax-functia-calculate\/#webpage","url":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-7-exemple-de-functii-dax-functia-calculate\/","name":"Power Pivot (7) \u2013 Exemple de Functii DAX. Functia CALCULATE -","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! :) Se da un Pivot Table de tip Power Pivot, construit in baza unui model de date format din mai multe tabele","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-7-exemple-de-functii-dax-functia-calculate\/#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-7-exemple-de-functii-dax-functia-calculate\/#mainImage","width":176,"height":178},"primaryImageOfPage":{"@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-7-exemple-de-functii-dax-functia-calculate\/#mainImage"},"datePublished":"2019-08-01T06:17:18+00:00","dateModified":"2020-01-20T06:58:40+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 (7) \u2013 Exemple de Functii DAX. Functia CALCULATE -","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! :) Se da un Pivot Table de tip Power Pivot, construit in baza unui model de date format din mai multe tabele","og:url":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-7-exemple-de-functii-dax-functia-calculate\/","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-08-01T06:17:18+00:00","article:modified_time":"2020-01-20T06:58:40+00:00","twitter:card":"summary_large_image","twitter:title":"Power Pivot (7) \u2013 Exemple de Functii DAX. Functia CALCULATE -","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! :) Se da un Pivot Table de tip Power Pivot, construit in baza unui model de date format din mai multe tabele","twitter:image":"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2015\/03\/SIGLA-BUNA-150x150.jpg"},"aioseo_meta_data":{"post_id":"936","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 (7) \u2013 Exemple de Functii DAX. Functia CALCULATE\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 (7) &#8211; Exemple de Functii DAX. Functia CALCULATE","link":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-7-exemple-de-functii-dax-functia-calculate\/"}],"_links":{"self":[{"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/posts\/936","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=936"}],"version-history":[{"count":2,"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/posts\/936\/revisions"}],"predecessor-version":[{"id":3352,"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/posts\/936\/revisions\/3352"}],"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=936"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/categories?post=936"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/tags?post=936"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}