{"id":832,"date":"2019-07-11T06:21:04","date_gmt":"2019-07-11T06:21:04","guid":{"rendered":"http:\/\/blog.eticsolutions.ro\/?p=832"},"modified":"2020-01-20T06:52:27","modified_gmt":"2020-01-20T06:52:27","slug":"power-pivot-cum-se-realizeza-legatura-intre-tabele","status":"publish","type":"post","link":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-cum-se-realizeza-legatura-intre-tabele\/","title":{"rendered":"Power Pivot (1) &#8211; Cum se realizeza legatura intre tabele"},"content":{"rendered":"<p><span style=\"color: #800000;\"><strong><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=\"128\" height=\"129\" 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: 128px) 100vw, 128px\" \/><\/a><span style=\"color: #000000;\">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. <\/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 dau doua tabele, denumite <strong>contracte<\/strong>, respectiv <strong>facturi<\/strong> (vezi <a href=\"http:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/cursuri-excel-gratuite-format-as-table-cum-se-realizeaza-si-la-ce-foloseste\/\"><span style=\"color: #800000;\"><strong>aici<\/strong><\/span><\/a> cum se realizeaza un tabel in Excel si la ce foloseste optiunea <strong>Format as Table<\/strong>).<\/p>\n<p>Analizand cele doua baze de date, se observa ca numarul contractului este <strong>cheia de legatura<\/strong> intre cele doua tabele, astfel:<\/p>\n<ul>\n<li>in baza de date de <strong>contracte<\/strong>, sunt introduse informatii referitoare la fiecare contract, cronologic, in ordinea semnarii acestora;<\/li>\n<li>in baza de date<strong> facturi<\/strong>, sunt introduse informatiile la facturile emise in baza contractelor semnate aflate in derulare;<\/li>\n<li>numarul de contract apare o singura data in baza de date <strong>contracte<\/strong> (un contract este introdus o singura data) si poate aparea de mai multe ori in baza de date<strong> facturi<\/strong> (se pot emite mai multe facturi pentru acelasi contract).<\/li>\n<\/ul>\n<p>Accesati meniul <strong>Data <\/strong>de pe bara de meniu si apasati butonul <strong>Relationships<\/strong>.<\/p>\n<figure id=\"attachment_827\" aria-describedby=\"caption-attachment-827\" style=\"width: 641px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_relationships1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-827\" src=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_relationships1.png\" alt=\"Power BI Create relationships - Microsoft Excel 2013\" width=\"641\" height=\"126\" srcset=\"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_relationships1.png 641w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_relationships1-300x59.png 300w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_relationships1-100x20.png 100w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_relationships1-150x29.png 150w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_relationships1-200x39.png 200w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_relationships1-450x88.png 450w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_relationships1-600x118.png 600w\" sizes=\"auto, (max-width: 641px) 100vw, 641px\" \/><\/a><figcaption id=\"caption-attachment-827\" class=\"wp-caption-text\"><strong>Power Pivot: Create relationships &#8211; Microsoft Excel 2013<\/strong><\/figcaption><\/figure>\n<p>Nu are importanta care este worksheet-ul activ. Tineti insa cont ca butonul <strong>Relationships<\/strong> <strong>NU<\/strong> este activ, daca in fisierul de lucru curent nu exista definit cel putin un tabel (Format as Table).<\/p>\n<p>In fereastra de dialog <strong>Manage Relationships<\/strong>, apasati butonul <strong>Add<\/strong>.<\/p>\n<p>Alegeti tabelul, respectiv campul de legatura pentru fiecare dintre cele doua tabele pentru care vreti sa definiti o relatie.<\/p>\n<figure id=\"attachment_828\" aria-describedby=\"caption-attachment-828\" style=\"width: 641px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_relationships2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-828\" src=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_relationships2.png\" alt=\"Power BI_Create realationship_Microsoft Excel 2013\" width=\"641\" height=\"194\" srcset=\"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_relationships2.png 641w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_relationships2-300x91.png 300w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_relationships2-100x30.png 100w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_relationships2-150x45.png 150w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_relationships2-200x61.png 200w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_relationships2-450x136.png 450w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_relationships2-600x182.png 600w\" sizes=\"auto, (max-width: 641px) 100vw, 641px\" \/><\/a><figcaption id=\"caption-attachment-828\" class=\"wp-caption-text\"><strong>Power Pivot: Create realationship &#8211; Microsoft Excel 2013<\/strong><\/figcaption><\/figure>\n<p><strong>Related Table<\/strong> este tabelul in care veti avea nevoie sa cautati ulterior dupa <strong>cheia de legatura<\/strong> (coloana).<\/p>\n<p><strong>Related Column<\/strong> <strong>(Primary)<\/strong> este coloana din tabel pe care veti cauta, in vreme ce <strong>Column (Foreign)<\/strong> este coloana de date care sunt cautate in coloana primara.<\/p>\n<p><span style=\"color: #800000;\"><strong><em><a href=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/semn-exclamare.gif\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-837 \" src=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/semn-exclamare-198x300.gif\" alt=\"semn exclamare\" width=\"42\" height=\"64\" srcset=\"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/semn-exclamare-198x300.gif 198w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/semn-exclamare-100x151.gif 100w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/semn-exclamare-150x227.gif 150w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/semn-exclamare-200x303.gif 200w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/semn-exclamare-300x454.gif 300w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/semn-exclamare-450x681.gif 450w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/semn-exclamare-600x908.gif 600w\" sizes=\"auto, (max-width: 42px) 100vw, 42px\" \/><\/a><span style=\"color: #000000;\">Nu este nevoie &#8211; <span style=\"color: #800000;\">DAR ESTE INDICAT<\/span> &#8211; ca cele doua coloane sa aiba aceeasi denumire. In exemplul de mai sus este doar o coincidenta, administratorul celor doua baze da date a denumit coloanele la fel pentru a le identifica mai usor. <\/span><\/em><\/strong><\/span><\/p>\n<p>Este, daca vreti, echivalentul argumentului <strong>lookup_vector<\/strong> din functia <strong>LOOKUP <\/strong>sau prima coloana din argumentul <strong>table_array<\/strong> al functiei <a href=\"http:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/exemplu-de-utilizare-a-functiei-vlookup\/\"><span style=\"color: #800000;\"><strong>VLOOKUP<\/strong><\/span><\/a>.<\/p>\n<p>In exemplul nostru, Related Table este baza de date <strong>contracte<\/strong>.<\/p>\n<p>Puteti defini oricate perechi de relatii intre mai multe baze de date. De exemplu, daca aveam si o baza de date denumita <strong>facturi_restante<\/strong>, puteam realiza o legatura intre baza de date <strong>facturi<\/strong> si baza de date <strong>facturi_restante<\/strong>, dupa numarul facturii fiscale (camp obligatoriu prezent in ambele baze de date!).<\/p>\n<p><span style=\"color: #800000;\"><strong>Modificarea\/stergerea unei legaturi intre tabele<\/strong><\/span><\/p>\n<p>Pentru a redefini sau sterge o legatura intre doua tabele, apasati butonul <strong>Relationships<\/strong> din meniul <strong>Data<\/strong>, selectati legatura pe care vreti sa o modificati si apasati unul din butoanele: <strong>Activate, Deactivate, Delete.<\/strong><\/p>\n<p>Puteti crea mai multe legaturi intre baze de date, dar sa nu aveti nevoie ca ele sa fie toate active in acelasi timp. Apasati butonul Relationships, selectati legatura pe care vreti sa o dezactivati si apasati butonul <strong>Deactivate.<\/strong><\/p>\n<p><span style=\"color: #800000;\"><strong>Realizarea legaturii intre tabele aflate in fisiere diferite<\/strong><\/span><\/p>\n<p>In momentul in care ati definit prima legatura intre doua tabele, Excel 2013 defineste\u00a0si <strong>Data Model<\/strong> initial, care contine cele doua tabele.<\/p>\n<p>Puteti vizualiza conexiunile existente in fisierul curent, apasand butonul <strong>Connections<\/strong> din meniul <strong>Data, <\/strong>sectiunea <strong>Connections.<\/strong><\/p>\n<figure id=\"attachment_830\" aria-describedby=\"caption-attachment-830\" style=\"width: 570px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_Workbook-connections.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-830 size-full\" src=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_Workbook-connections.png\" alt=\"Power BI_Workbook connections\" width=\"570\" height=\"393\" srcset=\"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_Workbook-connections.png 570w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_Workbook-connections-300x207.png 300w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_Workbook-connections-100x69.png 100w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_Workbook-connections-150x103.png 150w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_Workbook-connections-200x138.png 200w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_Workbook-connections-450x310.png 450w\" sizes=\"auto, (max-width: 570px) 100vw, 570px\" \/><\/a><figcaption id=\"caption-attachment-830\" class=\"wp-caption-text\"><strong>Power Pivot: Workbook connections &#8211; Microsoft Excel 2013<\/strong><\/figcaption><\/figure>\n<p>Daca vreti sa adaugati la model un tabel care nu se afla in fisierul curent, deschideti inainte respectivul fisier, verificati ca datele sunt formatate ca baza de date (utilizand <strong>Format as Table<\/strong>) si ca ati pus un nume usor de recunoscut tabelului respectiv.<\/p>\n<p>In fereastra de dialog de mai sus, apasati sageata din dreptul butonului <strong>Add<\/strong> si alegeti optiunea <strong>Add to the Data Model\u2026, <\/strong>apoi accesati submeniul <strong>Tables.<\/strong><\/p>\n<figure id=\"attachment_826\" aria-describedby=\"caption-attachment-826\" style=\"width: 500px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_Existingconnections.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-826 size-full\" src=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_Existingconnections.png\" alt=\"Power BI_Existingconnections\" width=\"500\" height=\"500\" srcset=\"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_Existingconnections.png 500w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_Existingconnections-150x150.png 150w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_Existingconnections-300x300.png 300w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_Existingconnections-100x100.png 100w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_Existingconnections-200x200.png 200w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_Existingconnections-450x450.png 450w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" \/><\/a><figcaption id=\"caption-attachment-826\" class=\"wp-caption-text\"><strong>Power Pivot: Add to the Data Model &#8211; Microsoft Excel 2013<\/strong><\/figcaption><\/figure>\n<p>Dati click pe worksheet-ul denumit <strong>FACT.RESTANTE<\/strong> din fisierul <strong>EXCEL 2013_Facturi restante.xlsx <\/strong>si apasati OK.<\/p>\n<p>In acest moment ati adaugat la modelul de date deja existent (format din tabelele <strong>contracte<\/strong> si <strong>facturi<\/strong>), inca o baza de date (denumita <strong>FACT_RESTANTE<\/strong>).<\/p>\n<figure id=\"attachment_831\" aria-describedby=\"caption-attachment-831\" style=\"width: 570px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_Workbook-connections_2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-831\" src=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_Workbook-connections_2.png\" alt=\"Power BI_Workbook connections_Microsoft Excel 2013\" width=\"570\" height=\"393\" srcset=\"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_Workbook-connections_2.png 570w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_Workbook-connections_2-300x207.png 300w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_Workbook-connections_2-100x69.png 100w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_Workbook-connections_2-150x103.png 150w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_Workbook-connections_2-200x138.png 200w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_Workbook-connections_2-450x310.png 450w\" sizes=\"auto, (max-width: 570px) 100vw, 570px\" \/><\/a><figcaption id=\"caption-attachment-831\" class=\"wp-caption-text\"><strong>Power Pivot: Workbook connections &#8211; Microsoft Excel 2013<\/strong><\/figcaption><\/figure>\n<p><span style=\"color: #800000;\"><strong><em><a href=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/semn-exclamare.gif\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-837 \" src=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/semn-exclamare-198x300.gif\" alt=\"semn exclamare\" width=\"32\" height=\"49\" srcset=\"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/semn-exclamare-198x300.gif 198w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/semn-exclamare-100x151.gif 100w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/semn-exclamare-150x227.gif 150w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/semn-exclamare-200x303.gif 200w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/semn-exclamare-300x454.gif 300w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/semn-exclamare-450x681.gif 450w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/semn-exclamare-600x908.gif 600w\" sizes=\"auto, (max-width: 32px) 100vw, 32px\" \/><\/a><\/em><\/strong><\/span><\/p>\n<p><strong><span style=\"color: #800000;\">Nu confundati numele foii de lucru (FACT.RESTANTE) cu numele bazei de date (tabelului), FACT_RESTANTE.<\/span><\/strong><\/p>\n<p>&nbsp;<\/p>\n<p>Dupa ce ati adaugat la modelul de lucru si noul tabel (aflat in alt fisier decat cel curent), puteti realiza mai departe o noua legatura intre tabele, de data aceasta intre tabelul <strong>facturi<\/strong> si tabelul <strong>FACT_RESTANTE<\/strong>.<\/p>\n<p>In fereastra de dialog care apare la apasarea butonul <strong>Relationships<\/strong> din meniul <strong>Data<\/strong>, observati ca din rubrica <strong>Table, <\/strong>respectiv <strong>Related Table<\/strong> puteti selecta acum si tabelul <strong>FACT_RESTANTE<\/strong>.<\/p>\n<figure id=\"attachment_829\" aria-describedby=\"caption-attachment-829\" style=\"width: 641px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_relationships3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-829\" src=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_relationships3.png\" alt=\"Power BI_Create relationship_Microsoft Excel 2013\" width=\"641\" height=\"194\" srcset=\"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_relationships3.png 641w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_relationships3-300x91.png 300w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_relationships3-100x30.png 100w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_relationships3-150x45.png 150w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_relationships3-200x61.png 200w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_relationships3-450x136.png 450w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Power-BI_relationships3-600x182.png 600w\" sizes=\"auto, (max-width: 641px) 100vw, 641px\" \/><\/a><figcaption id=\"caption-attachment-829\" class=\"wp-caption-text\"><strong>Power Pivot: Create relationship &#8211; Microsoft Excel 2013<\/strong><\/figcaption><\/figure>\n<p>Related Table este chiar tabelul <strong>FACT_RESTANTE<\/strong>, in care Related Column (Primary) &#8211; echivalentul coloanei <strong>lookup_vector<\/strong> din functia LOOKUP (sau prima coloana din argumentul <strong>table_array<\/strong> al functiei VLOOKUP) &#8211; va fi coloana care contine numerele unice de facturi fiscale (coloana <strong>nr. FF<\/strong>) restante, adica neplatite pana la data ultimei actualizari a tabelului.<\/p>\n<p>De altfel, si numerele de facturi fiscale din coloana\u00a0<strong>Nr. Factura Fiscala<\/strong> din tabelul\u00a0<strong>facturi<\/strong> sunt tot unice, insa nu toate facturile fiscale apar si in\u00a0tabelul\u00a0<strong>FACT_RESTANTE<\/strong>, ci doar acelea neplatite inca.<\/p>\n<p>Toate datele aferente conexiunilor (legaturilor) definite se vor incarca (actualiza) in modelul de date, la apasarea butonului <strong>Refresh All <\/strong>din meniul <strong>Data<\/strong>.<\/p>\n<p>In alte articole dedicate Power Pivot, vom descrie mai in detaliu cum se utilizeaza <strong>Data Model, <\/strong>cum se realizeaza un Power Pivot si care sunt optiunile de prelucrare utilizand functii de tip DAX.<\/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 cursuri gratuite dedicate Power Pivot pentru Excel 2013. ENJOY THE POWER! \ud83d\ude42 &nbsp; Se dau doua tabele, denumite contracte, respectiv facturi (vezi aici cum se realizeaza un tabel in Excel si la ce [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":841,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[171],"tags":[167,65,90,169,165,170,166,168],"class_list":["post-832","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-power-pivot","tag-creare-legaturi-tabele","tag-cursuri-excel","tag-cursuri-excel-gratuite","tag-data-model","tag-format-as-table","tag-power-bi","tag-power-pivot","tag-vlookup"],"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 dau doua tabele, denumite contracte, respectiv facturi (vezi aici cum se realizeaza un tabel in Excel si la ce\" \/>\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-cum-se-realizeza-legatura-intre-tabele\/\" \/>\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 (1) \u2013 Cum se realizeza legatura intre tabele -\" \/>\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 dau doua tabele, denumite contracte, respectiv facturi (vezi aici cum se realizeaza un tabel in Excel si la ce\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-cum-se-realizeza-legatura-intre-tabele\/\" \/>\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-11T06:21:04+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-01-20T06:52:27+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Power Pivot (1) \u2013 Cum se realizeza legatura intre tabele -\" \/>\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 dau doua tabele, denumite contracte, respectiv facturi (vezi aici cum se realizeaza un tabel in Excel si la ce\" \/>\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-cum-se-realizeza-legatura-intre-tabele\\\/#blogposting\",\"name\":\"Power Pivot (1) \\u2013 Cum se realizeza legatura intre tabele -\",\"headline\":\"Power Pivot (1) &#8211; Cum se realizeza legatura intre tabele\",\"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-11T06:21:04+00:00\",\"dateModified\":\"2020-01-20T06:52:27+00:00\",\"inLanguage\":\"en-US\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/power-pivot\\\/power-pivot-cum-se-realizeza-legatura-intre-tabele\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/power-pivot\\\/power-pivot-cum-se-realizeza-legatura-intre-tabele\\\/#webpage\"},\"articleSection\":\"Power Pivot, creare legaturi tabele, cursuri excel, cursuri excel gratuite, Data Model, Format as Table, Power BI, Power Pivot, Vlookup\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/power-pivot\\\/power-pivot-cum-se-realizeza-legatura-intre-tabele\\\/#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-cum-se-realizeza-legatura-intre-tabele\\\/#listItem\",\"name\":\"Power Pivot (1) &#8211; Cum se realizeza legatura intre tabele\"},\"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-cum-se-realizeza-legatura-intre-tabele\\\/#listItem\",\"position\":5,\"name\":\"Power Pivot (1) &#8211; Cum se realizeza legatura intre tabele\",\"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-cum-se-realizeza-legatura-intre-tabele\\\/#organizationLogo\",\"width\":150,\"height\":150},\"image\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/power-pivot\\\/power-pivot-cum-se-realizeza-legatura-intre-tabele\\\/#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-cum-se-realizeza-legatura-intre-tabele\\\/#webpage\",\"url\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/power-pivot\\\/power-pivot-cum-se-realizeza-legatura-intre-tabele\\\/\",\"name\":\"Power Pivot (1) \\u2013 Cum se realizeza legatura intre tabele -\",\"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 dau doua tabele, denumite contracte, respectiv facturi (vezi aici cum se realizeaza un tabel in Excel si la ce\",\"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-cum-se-realizeza-legatura-intre-tabele\\\/#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-cum-se-realizeza-legatura-intre-tabele\\\/#mainImage\",\"width\":176,\"height\":178},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/power-pivot\\\/power-pivot-cum-se-realizeza-legatura-intre-tabele\\\/#mainImage\"},\"datePublished\":\"2019-07-11T06:21:04+00:00\",\"dateModified\":\"2020-01-20T06:52:27+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 (1) \u2013 Cum se realizeza legatura intre tabele -","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 dau doua tabele, denumite contracte, respectiv facturi (vezi aici cum se realizeaza un tabel in Excel si la ce","canonical_url":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-cum-se-realizeza-legatura-intre-tabele\/","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-cum-se-realizeza-legatura-intre-tabele\/#blogposting","name":"Power Pivot (1) \u2013 Cum se realizeza legatura intre tabele -","headline":"Power Pivot (1) &#8211; Cum se realizeza legatura intre tabele","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-11T06:21:04+00:00","dateModified":"2020-01-20T06:52:27+00:00","inLanguage":"en-US","mainEntityOfPage":{"@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-cum-se-realizeza-legatura-intre-tabele\/#webpage"},"isPartOf":{"@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-cum-se-realizeza-legatura-intre-tabele\/#webpage"},"articleSection":"Power Pivot, creare legaturi tabele, cursuri excel, cursuri excel gratuite, Data Model, Format as Table, Power BI, Power Pivot, Vlookup"},{"@type":"BreadcrumbList","@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-cum-se-realizeza-legatura-intre-tabele\/#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-cum-se-realizeza-legatura-intre-tabele\/#listItem","name":"Power Pivot (1) &#8211; Cum se realizeza legatura intre tabele"},"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-cum-se-realizeza-legatura-intre-tabele\/#listItem","position":5,"name":"Power Pivot (1) &#8211; Cum se realizeza legatura intre tabele","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-cum-se-realizeza-legatura-intre-tabele\/#organizationLogo","width":150,"height":150},"image":{"@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-cum-se-realizeza-legatura-intre-tabele\/#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-cum-se-realizeza-legatura-intre-tabele\/#webpage","url":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-cum-se-realizeza-legatura-intre-tabele\/","name":"Power Pivot (1) \u2013 Cum se realizeza legatura intre tabele -","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 dau doua tabele, denumite contracte, respectiv facturi (vezi aici cum se realizeaza un tabel in Excel si la ce","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-cum-se-realizeza-legatura-intre-tabele\/#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-cum-se-realizeza-legatura-intre-tabele\/#mainImage","width":176,"height":178},"primaryImageOfPage":{"@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-cum-se-realizeza-legatura-intre-tabele\/#mainImage"},"datePublished":"2019-07-11T06:21:04+00:00","dateModified":"2020-01-20T06:52:27+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 (1) \u2013 Cum se realizeza legatura intre tabele -","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 dau doua tabele, denumite contracte, respectiv facturi (vezi aici cum se realizeaza un tabel in Excel si la ce","og:url":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-cum-se-realizeza-legatura-intre-tabele\/","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-11T06:21:04+00:00","article:modified_time":"2020-01-20T06:52:27+00:00","twitter:card":"summary_large_image","twitter:title":"Power Pivot (1) \u2013 Cum se realizeza legatura intre tabele -","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 dau doua tabele, denumite contracte, respectiv facturi (vezi aici cum se realizeaza un tabel in Excel si la ce","twitter:image":"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2015\/03\/SIGLA-BUNA-150x150.jpg"},"aioseo_meta_data":{"post_id":"832","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:49:57","updated":"2026-06-29 09:49:57"},"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 (1) \u2013 Cum se realizeza legatura intre tabele\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 (1) &#8211; Cum se realizeza legatura intre tabele","link":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-cum-se-realizeza-legatura-intre-tabele\/"}],"_links":{"self":[{"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/posts\/832","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=832"}],"version-history":[{"count":9,"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/posts\/832\/revisions"}],"predecessor-version":[{"id":900,"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/posts\/832\/revisions\/900"}],"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=832"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/categories?post=832"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/tags?post=832"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}