{"id":913,"date":"2022-06-13T08:27:16","date_gmt":"2022-06-13T06:27:16","guid":{"rendered":"http:\/\/kalkulacija.com\/wordpress\/?p=913"},"modified":"2022-06-13T13:48:58","modified_gmt":"2022-06-13T11:48:58","slug":"power-pivot-tabele","status":"publish","type":"post","link":"https:\/\/kalkulacija.com\/wordpress\/power-pivot-tabele\/","title":{"rendered":"[:sr]Prava mo\u0107 Power pivot tabele[:en]THE REAL POWER OF POWER PIVOT TABLES[:]"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_87_1 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">[:sr]Sadr\u017eaj[:en] Contents[:]<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #0d590e;color:#0d590e\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #0d590e;color:#0d590e\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/kalkulacija.com\/wordpress\/power-pivot-tabele\/#Prednosti_power_pivot_tabele\" >Prednosti power pivot tabele<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/kalkulacija.com\/wordpress\/power-pivot-tabele\/#Priprema_podataka\" >Priprema podataka<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/kalkulacija.com\/wordpress\/power-pivot-tabele\/#Model_podataka\" >Model podataka<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/kalkulacija.com\/wordpress\/power-pivot-tabele\/#Uspostavljanje_relacija\" >Uspostavljanje relacija<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/kalkulacija.com\/wordpress\/power-pivot-tabele\/#Primena_DAX_formula\" >Primena DAX formula<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/kalkulacija.com\/wordpress\/power-pivot-tabele\/#Advantages_of_power_pivot_table\" >Advantages of power pivot table<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/kalkulacija.com\/wordpress\/power-pivot-tabele\/#Data_preparation\" >Data preparation<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/kalkulacija.com\/wordpress\/power-pivot-tabele\/#Data_model\" >Data model<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/kalkulacija.com\/wordpress\/power-pivot-tabele\/#Establishing_relationships\" >Establishing relationships<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/kalkulacija.com\/wordpress\/power-pivot-tabele\/#Application_of_DAX_formula\" >Application of DAX formula<\/a><\/li><\/ul><\/nav><\/div>\n[:sr]Power pivot (unapre\u0111ena izvedena) tabela obuhvata postupak izrade izve\u0161tajne tabele veoma sli\u010dan <a href=\"https:\/\/kalkulacija.com\/wordpress\/izvedene-pivot-tabele\/\">Pivot tabeli<\/a>, \u010dija je osnovna prednost agregiranje\/grupisanje podataka iz po\u010detne tabele koja sadr\u017ei vi\u0161e od milion redova (ta\u010dnije 1.048.576 redova, zna\u010di preko 1 milion redova).<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Prednosti_power_pivot_tabele\"><\/span>Prednosti power pivot tabele<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Kako bi uo\u010dili dobre razloge zbog kojih vredi ovladati unapre\u0111enom izvedenom (power pivot) tabelom\u00a0 pogledajmo slede\u0107i pregled zadataka koje naj\u010de\u0161\u0107e radimo u excelu.<\/p>\n<hr \/>\n<p><span style=\"font-size: small;\"><strong>Zadatak 1.<\/strong><br \/>\nUvoz podataka iz razli\u010ditih izvora kao \u0161to su baze\u00a0 podataka, javni izvori, tabelarni formati, i tekstualne datoteke.<br \/>\n<strong>Izvedena (pivot) tabela<\/strong><br \/>\nUvoz 1048567 redova tabele\u00a0 u radni prostor, mogu\u0107nost izmene podatka u postoje\u0107oj tabeli.<br \/>\n<strong>Unapre\u0111ena izvedena (power pivot) tabela<\/strong><br \/>\nKonekcija sa\u00a0 razli\u010ditim izvorima podataka, filtriranje, promena imena kolona i imena tabela, bez mogu\u0107nosti promene podataka, neograni\u010den broj redova ( tehni\u010dki do 2,097 milijarde redova).<\/span><\/p>\n<hr \/>\n<p><span style=\"font-size: small;\"><strong>Zadatak 2.<\/strong><br \/>\nPovezivanje podataka iz razli\u010ditih tabela, izrada hijerarhije, grupa dimenzija i indikatora uspeha (KPI).<br \/>\n<strong>Izvedena (pivot) tabela<\/strong><br \/>\nPovezivanje se obavlja upotrebom VLOOKUP funkcije ili relacije u<strong>\u00a0Data\/Relationships<\/strong>, nema izrade hijerarhije, ima grupisanje u izvedenoj tabeli (Rows i Columns okno), ne poseduje izradu indikatora uspeha (KPI).<br \/>\n<strong>Unapre\u0111ena izvedena (power pivot) tabela<\/strong><br \/>\nPovezivanje se obavlja upotrebom <strong>Diagram view<\/strong> u power pivot dodatku, mo\u017ee izraditi hijerarhiski pregled i grupisati dimenzije upotrebom DAX formula u obra\u010dunskim kolonama i obra\u010dunskim poljima i na osnovu definisanih dimenzija ima mogu\u0107nost izrade indikatora uspeha (KPI).<br \/>\n<\/span><\/p>\n<hr \/>\n<p><span style=\"font-size: small;\"><strong>Zadatak 3.<\/strong><br \/>\nIzrada kalkulacija upotrebom funkcija i formula.<br \/>\n<strong>Izvedena (pivot) tabela<\/strong><br \/>\nUpotreba oko 455 Excel formula i mogu\u0107nost upotrebe VBA dodataka (eng. Visual Basic for Applications) za izradu novih funkcija.<br \/>\n<strong>Unapre\u0111ena izvedena (power pivot) tabela<\/strong><br \/>\nUpotreba posebnog seta 259 DAX formula (eng. Data Analysis Expressions), nema mogu\u0107nost VBA programiranja novih korisni\u010dkih funkcija.<br \/>\n<\/span><\/p>\n<hr \/>\n<p>Razlikuje se po tome \u0161to je zasnovan na podacima koji se nalaze u Modelu podataka.<\/p>\n<div style=\"background-color: #9999ff;\">\n<p><strong>\u00a0Radni koraci:<\/strong><\/p>\n<ol>\n<li>Priprema podataka za u\u010ditavanje u model,<\/li>\n<li>Uspostavljanje relacija izme\u0111u tabela,<\/li>\n<li>Primena DAX formula u tabelama,<\/li>\n<li>Izrada pivot tabele iz PowerPivot dodatka,<\/li>\n<li>Prilago\u0111avanje prikaza podataka u \u017eeljenoj formi za izve\u0161tavanje.<\/li>\n<\/ol>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Priprema_podataka\"><\/span>Priprema podataka<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Koliko \u0107e trajati priprema podataka koji \u0107e se obra\u0111ivati u Power pivot dodatku najvi\u0161e zavisi od stanja izvora gde su ti podaci. Ako je re\u010d razli\u010ditim formatima, tehnolo\u0161koj platformi, organizaciji podataka o samoj pripremi vi\u0161e se mo\u017ee pro\u010ditati u tekstu o\u00a0<a href=\"https:\/\/kalkulacija.com\/wordpress\/2017\/09\/07\/power-query-mocni-upiti\/\">Power Query<\/a>\u00a0dodatku. Ako je re\u010d o podacima u eksel tabelama preporu\u010dujem da &#8220;vizuelne&#8221; tabele transformi\u0161ete u objekte jednostavno nakon selekcije jedne \u010delije pritisnite na kombinaciju <strong>Ctrl+T <\/strong>kao na slede\u0107oj slici.<\/p>\n<figure id=\"attachment_923\" aria-describedby=\"caption-attachment-923\" style=\"width: 840px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-923\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp1.png\" alt=\"power pivot\" width=\"840\" height=\"562\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp1.png 840w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp1-350x234.png 350w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp1-300x201.png 300w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp1-768x514.png 768w\" sizes=\"auto, (max-width: 840px) 100vw, 840px\" \/><figcaption id=\"caption-attachment-923\" class=\"wp-caption-text\">Kreiranje objekta Tabele<\/figcaption><\/figure>\n<p>To uradite za sve tabele koje u\u010destvuju u va\u0161oj analizi i svakako odredite im odgovaraju\u0107e ime tabele kako bi ste lak\u0161e i br\u017ee radili obradu.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Model_podataka\"><\/span>Model podataka<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Sada svaku tabelu dodajte u model podataka klikom na dugme <strong>Add to Data Model<\/strong> kao na slede\u0107oj slici. <img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-924\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp2.png\" alt=\"\" width=\"836\" height=\"585\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp2.png 836w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp2-350x245.png 350w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp2-300x210.png 300w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp2-768x537.png 768w\" sizes=\"auto, (max-width: 836px) 100vw, 836px\" \/> Model mo\u017ee da barata sa velikom koli\u010dinom podataka.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Uspostavljanje_relacija\"><\/span>Uspostavljanje relacija<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Slede\u0107i korak koji treba preduzeti je da u dodatku <strong>PowerPivot<\/strong> na traci sa alatima <strong>Home<\/strong> odaberete <strong>Diagram View<\/strong> (krajnje desno). Dobi\u0107ete sadr\u017eaj sli\u010dan slede\u0107oj slici. <img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-927\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp3.png\" alt=\"\" width=\"1217\" height=\"730\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp3.png 1217w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp3-350x210.png 350w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp3-300x180.png 300w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp3-768x461.png 768w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp3-1024x614.png 1024w\" sizes=\"auto, (max-width: 1217px) 100vw, 1217px\" \/> Klikom na <strong>Data View<\/strong> vratite se u tabelarni prikaz podataka i izaberite tabelu u kojoj \u0107e te izra\u010dunati \u017eeljene podatke.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Primena_DAX_formula\"><\/span>Primena DAX formula<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>U na\u0161em primeru to bi zna\u010dilo da odete u tabelu Promet i da u novoj koloni Add Column dodate slede\u0107u formulu. <span style=\"color: #008000;\"><strong>=Promet[kom]*(1-Promet[rabat])*RELATED(Cenovnik[cena_proizvoda])<\/strong><\/span> Gde izra\u010dunavamo iznos mno\u017eenjem podatka iz kolone KOM (broj komada) umanjujemo za iznos rabata kolona RABAT i pozivamo cenu za dati proizvod iz pripadaju\u0107eg cenovnika RELATED(Cenovnik[cena_proizvoda]) kao na slede\u0107oj slici. <img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-930\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp4.png\" alt=\"\" width=\"816\" height=\"599\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp4.png 816w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp4-350x257.png 350w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp4-300x220.png 300w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp4-768x564.png 768w\" sizes=\"auto, (max-width: 816px) 100vw, 816px\" \/> Kada zavr\u0161imo sve potrebne kalkulacije mo\u017eemo pristupiti izradi Pivot tabele klikom na dugme <strong>PivotTable<\/strong> sa Home trake u Power Pivot dodatku. kao na slede\u0107oj slici. <img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-933\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp5.png\" alt=\"\" width=\"813\" height=\"589\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp5.png 813w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp5-350x254.png 350w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp5-300x217.png 300w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp5-768x556.png 768w\" sizes=\"auto, (max-width: 813px) 100vw, 813px\" \/> Sada smo se vratili u Excel i mo\u017eemo pristupiti daljem prilago\u0111avanju pivot tabele kako bi je doveli u \u017eeljenu formu za izve\u0161tavanje. Ura\u0111eni primer se mo\u017ee preuzeti\u00a0<a href=\"https:\/\/kalkulacija.com\/napredniexcel\/Primer%20tri%20tabele%20PowerPivot.xlsx\">ovde<\/a>. Power Pivot Uputstvo mo\u017eete preuzeti \t\t<script src=\"https:\/\/www.google.com\/recaptcha\/api.js\" async defer><\/script>\t\t<div class=\"email_download_link\">\r\n\t\t\t\t\t\t<form action=\"#\" method=\"post\" class=\"ed_form\" id=\"ed_form_1789553968\">\r\n\t\t\t\t<p><span class=\"name\">Name *<\/span><br><input type=\"text\" name=\"name\" id=\"name\" placeholder=\"Name\" value=\"\" maxlength=\"50\" required\/><\/p>\t\t\t\t<p><span class=\"email\">Email *<\/span><br><input class=\"\" type=\"email\" id=\"email\" name=\"email\" value=\"\" placeholder=\"Email *\"  maxlength=\"225\" required\/><\/p>\t\t\t\t\t\t\t\t\t\t\t\t<p><input type=\"checkbox\" name=\"gdpr\" id=\"gdpr\" value=\"YES\"> <a href=\"https:\/\/kalkulacija.com\/wordpress\/politika-privatnosti\/\" target=\"_blank\">GDPR saglasnost za \u010duvanje emaila \/ GDPR consent to save email<\/a><\/p>\t\t\t\t<p><div class=\"g-recaptcha\" data-sitekey=\"6LfKPA4UAAAAADCRvP7_0Rmx03ygOZOhfsLi0Lnl\"><\/div><\/p>\t\t\t\t<br \/>\r\n\t\t\t\t<input name=\"submit\" class=\"submit\" id=\"ed_form_submit_1789553968\" value=\"Send Download Link\" type=\"submit\" \/>\r\n\t\t\t\t<span class=\"ed_form_spinner\" id=\"loading-image\" style=\"display:none;\">\r\n\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/plugins\/email-download-link\/images\/ajax-loader.gif\" \/>\r\n\t\t\t\t<\/span>\r\n\t\t\t\t<input name=\"guid\" id=\"guid\" value=\"gqlmbn-zogxwu-wbvzlu-hrvjue-uvjehk\" type=\"hidden\"\/>\r\n\t\t\t\t<input type=\"text\" style=\"display:none;\" id=\"email_name\" name=\"email_name\" value=\"\" type=\"hidden\"\/>\r\n\t\t\t\t<input name=\"form_nonce\" id=\"form_nonce\" value=\"a099cde4b2\" type=\"hidden\"\/>\r\n\t\t\t\t<input name=\"name_mand\" id=\"name_mand\" value=\"YES\" type=\"hidden\"\/>\r\n\t\t\t\t<input name=\"gdpr_mand\" id=\"gdpr_mand\" value=\"YES\" type=\"hidden\"\/>\r\n\t\t\t\t<input name=\"phone_mand\" id=\"phone_mand\" value=\"\" type=\"hidden\"\/>\r\n\t\t\t<\/form>\t\r\n\t\t\t<span class=\"ed_form_message\" id=\"ed_form_message_1789553968\"><\/span>\r\n\t\t<\/div>\r\n\t[:en]<span>Power pivot (advanced derived) table includes the process of creating a report table very similar to\u00a0<\/span><a href=\"https:\/\/kalkulacija.com\/wordpress\/izvedene-pivot-tabele\/\"><span>the Pivot table<\/span><\/a><span>\u00a0, whose main advantage is aggregating \/ grouping data from the initial table containing more than a million rows (1,048,576 rows, meaning over 1 million rows).<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Advantages_of_power_pivot_table\"><\/span><span id=\"Prednosti_power_pivot_tabele\" class=\"ez-toc-section\"><\/span><span>Advantages of power pivot table<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span>In order to notice the good reasons why it is worth mastering the advanced power pivot table, let&#8217;s take a look at the following overview of the tasks we usually do in excel.<\/span><\/p>\n<hr \/>\n<p><strong><span>Task 1.<\/span><\/strong><br \/>\n<span>Import data from various sources such as databases, public sources, spreadsheet formats, and text files.<\/span><br \/>\n<strong><span>Derived (pivot) table<\/span><\/strong><br \/>\n<span>Import 1048567 rows of the table into the workspace, the ability to change the data in the existing table.<\/span><br \/>\n<strong><span>Improved power pivot<\/span><\/strong><br \/>\n<span>Connection with various data sources, filtering, renaming columns and table names, without the possibility of changing the data, unlimited number of rows (technically up to 2.097 billion rows).<\/span><\/p>\n<hr \/>\n<p><strong><span>Task 2.<\/span><\/strong><br \/>\n<span>Linking data from different tables, creating hierarchies, groups of dimensions and success indicators (KPI).<\/span><br \/>\n<strong><span>PivotTable The<\/span><\/strong><br \/>\n<span>connection is made using the VLOOKUP function or relation in\u00a0<\/span><strong><span>\u00a0Data \/ Relationships<\/span><\/strong><span>\u00a0, there is no hierarchy creation, there is grouping in the derived table (Rows and Columns pane), there is no creation of success indicators (KPI).<\/span><br \/>\n<strong><span>Improved power pivot table<\/span><\/strong><br \/>\n<span>Connection is done using\u00a0<\/span><strong><span>Diagram view<\/span><\/strong><span>\u00a0in power pivot plugin, can create hierarchical overview and group dimensions using DAX formulas in calculation columns and calculation fields and based on defined dimensions has the ability to create success indicators (KPI).<\/span><\/p>\n<hr \/>\n<p><strong><span>Task 3.<\/span><\/strong><br \/>\n<span>Making calculations using functions and formulas.<\/span><br \/>\n<strong><span>PivotTable<\/span><\/strong><br \/>\n<span>Use about 455 Excel formulas and the ability to use VBA plug-ins (Visual Basic for Applications) to create new functions.<\/span><br \/>\n<strong><span>Improved power pivot table<\/span><\/strong><br \/>\n<span>Using a special set of 259 DAX formulas (Data Analysis Expressions), there is no possibility of VBA programming of new user functions.<\/span><\/p>\n<hr \/>\n<p><span>It differs in that it is based on the data contained in the Data Model.<\/span><\/p>\n<div>\n<p><strong>\u00a0Working steps:<\/strong><\/p>\n<ol>\n<li>Preparation of data for loading into the model,<\/li>\n<li>Establishing relationships between tables,<\/li>\n<li>Application of DAX formulas in tables,<\/li>\n<li>Creating a pivot table from the PowerPivot plugin,<\/li>\n<li>Customize the display of data in the desired reporting form.<\/li>\n<\/ol>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Data_preparation\"><\/span><span id=\"Priprema_podataka\" class=\"ez-toc-section\"><\/span>Data preparation<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>How long it will take to prepare the data that will be processed in the Power pivot add-on mostly depends on the state of the source where the data is.\u00a0If we are talking about different formats, technological platform, organization of data on the preparation itself, you can read more in the text about the\u00a0\u00a0<a href=\"https:\/\/kalkulacija.com\/wordpress\/2017\/09\/07\/power-query-mocni-upiti\/\">Power Query<\/a>\u00a0\u00a0add-on.<\/p>\n<p>When it comes to data in excel tables, I recommend that you transform &#8220;visual&#8221; tables into objects simply after selecting one cell, press\u00a0<strong>Ctrl + T<\/strong>\u00a0as in the following figure.<\/p>\n<figure id=\"attachment_923\" class=\"wp-caption alignnone\" aria-describedby=\"caption-attachment-923\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-923\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp1.png\" sizes=\"auto, (max-width: 840px) 100vw, 840px\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp1.png 840w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp1-350x234.png 350w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp1-300x201.png 300w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp1-768x514.png 768w\" alt=\"power pivot\" width=\"840\" height=\"562\" \/><figcaption id=\"caption-attachment-923\" class=\"wp-caption-text\">Creating a Table object<\/figcaption><\/figure>\n<p>Do this for all tables that participate in your analysis, and be sure to assign them the appropriate table name to make processing easier and faster.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Data_model\"><\/span><span id=\"Model_podataka\" class=\"ez-toc-section\"><\/span>Data model<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Now add each table to the data model by clicking the\u00a0<strong>Add to Data Model<\/strong>\u00a0button as in the following figure.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-924\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp2.png\" sizes=\"auto, (max-width: 836px) 100vw, 836px\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp2.png 836w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp2-350x245.png 350w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp2-300x210.png 300w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp2-768x537.png 768w\" alt=\"\" width=\"836\" height=\"585\" \/><\/p>\n<p>The model can handle a large amount of data.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Establishing_relationships\"><\/span><span id=\"Uspostavljanje_relacija\" class=\"ez-toc-section\"><\/span>Establishing relationships<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The next step you need to take is to\u00a0select\u00a0<strong>Diagram View<\/strong>\u00a0(far right) in the\u00a0<strong>PowerPivot plugin on the\u00a0<\/strong><strong>Home<\/strong>\u00a0toolbar .<\/p>\n<p>You will get content similar to the following image.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-927\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp3.png\" sizes=\"auto, (max-width: 1217px) 100vw, 1217px\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp3.png 1217w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp3-350x210.png 350w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp3-300x180.png 300w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp3-768x461.png 768w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp3-1024x614.png 1024w\" alt=\"\" width=\"1217\" height=\"730\" \/><\/p>\n<p>Click on\u00a0<strong>Data View<\/strong>\u00a0to return to the tabular data view and select the table in which you will calculate the desired data.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Application_of_DAX_formula\"><\/span><span id=\"Primena_DAX_formula\" class=\"ez-toc-section\"><\/span>Application of DAX formula<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>In our example, this would mean going to the Traffic table and adding the following formula in the new Add Column column.<\/p>\n<p><strong>= Turnover [pcs] * (1-Turnover [discount]) * RELATED (Price list [price_product])<\/strong><\/p>\n<p>Where we calculate the amount by multiplying the data from the KOM column (number of pieces) we reduce by the amount of the rebate of the RABAT column and call the price for a given product from the corresponding price list RELATED (Price list [product_price]) as in the following figure.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-930\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp4.png\" sizes=\"auto, (max-width: 816px) 100vw, 816px\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp4.png 816w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp4-350x257.png 350w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp4-300x220.png 300w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp4-768x564.png 768w\" alt=\"\" width=\"816\" height=\"599\" \/><\/p>\n<p>When we have completed all the necessary calculations, we can start creating a Pivot table by clicking on the\u00a0<strong>PivotTable<\/strong>\u00a0button from the Home bar in the Power Pivot plugin.\u00a0as in the following figure.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-933\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp5.png\" sizes=\"auto, (max-width: 813px) 100vw, 813px\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp5.png 813w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp5-350x254.png 350w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp5-300x217.png 300w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp5-768x556.png 768w\" alt=\"\" width=\"813\" height=\"589\" \/><\/p>\n<p>We have now returned to Excel and can proceed to further customize the pivot table to bring it into the desired reporting form.<\/p>\n<p>The prepared example can be download <a href=\"https:\/\/kalkulacija.com\/napredniexcel\/Primer%20tri%20tabele%20PowerPivot.xlsx\">here.<\/a><\/p>\n<div class=\"kk-star-ratings kksr-valign-bottom kksr-align-right kksr-disabled\" data-payload=\"{&quot;align&quot;:&quot;right&quot;,&quot;id&quot;:&quot;913&quot;,&quot;readonly&quot;:&quot;1&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;bottom&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;count&quot;:&quot;1&quot;,&quot;score&quot;:&quot;5&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Ocenite post&quot;,&quot;legend&quot;:&quot;5\\\/5 - (1 vote)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;width&quot;:&quot;142.5&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;}\">\n<div class=\"kksr-stars\">\n<div class=\"kksr-stars-inactive\">\n<div class=\"kksr-star\" data-star=\"1\">\n<p>Power Pivot Tutorial can download<\/p>\n\t\t<script src=\"https:\/\/www.google.com\/recaptcha\/api.js\" async defer><\/script>\t\t<div class=\"email_download_link\">\r\n\t\t\t\t\t\t<form action=\"#\" method=\"post\" class=\"ed_form\" id=\"ed_form_1789553968\">\r\n\t\t\t\t<p><span class=\"name\">Name *<\/span><br><input type=\"text\" name=\"name\" id=\"name\" placeholder=\"Name\" value=\"\" maxlength=\"50\" required\/><\/p>\t\t\t\t<p><span class=\"email\">Email *<\/span><br><input class=\"\" type=\"email\" id=\"email\" name=\"email\" value=\"\" placeholder=\"Email *\"  maxlength=\"225\" required\/><\/p>\t\t\t\t\t\t\t\t\t\t\t\t<p><input type=\"checkbox\" name=\"gdpr\" id=\"gdpr\" value=\"YES\"> <a href=\"https:\/\/kalkulacija.com\/wordpress\/politika-privatnosti\/\" target=\"_blank\">GDPR saglasnost za \u010duvanje emaila \/ GDPR consent to save email<\/a><\/p>\t\t\t\t<p><div class=\"g-recaptcha\" data-sitekey=\"6LfKPA4UAAAAADCRvP7_0Rmx03ygOZOhfsLi0Lnl\"><\/div><\/p>\t\t\t\t<br \/>\r\n\t\t\t\t<input name=\"submit\" class=\"submit\" id=\"ed_form_submit_1789553968\" value=\"Send Download Link\" type=\"submit\" \/>\r\n\t\t\t\t<span class=\"ed_form_spinner\" id=\"loading-image\" style=\"display:none;\">\r\n\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/plugins\/email-download-link\/images\/ajax-loader.gif\" \/>\r\n\t\t\t\t<\/span>\r\n\t\t\t\t<input name=\"guid\" id=\"guid\" value=\"gqlmbn-zogxwu-wbvzlu-hrvjue-uvjehk\" type=\"hidden\"\/>\r\n\t\t\t\t<input type=\"text\" style=\"display:none;\" id=\"email_name\" name=\"email_name\" value=\"\" type=\"hidden\"\/>\r\n\t\t\t\t<input name=\"form_nonce\" id=\"form_nonce\" value=\"a099cde4b2\" type=\"hidden\"\/>\r\n\t\t\t\t<input name=\"name_mand\" id=\"name_mand\" value=\"YES\" type=\"hidden\"\/>\r\n\t\t\t\t<input name=\"gdpr_mand\" id=\"gdpr_mand\" value=\"YES\" type=\"hidden\"\/>\r\n\t\t\t\t<input name=\"phone_mand\" id=\"phone_mand\" value=\"\" type=\"hidden\"\/>\r\n\t\t\t<\/form>\t\r\n\t\t\t<span class=\"ed_form_message\" id=\"ed_form_message_1789553968\"><\/span>\r\n\t\t<\/div>\r\n\t\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n[:]\n\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-right kksr-valign-bottom\"\n    data-payload='{&quot;align&quot;:&quot;right&quot;,&quot;id&quot;:&quot;913&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;bottom&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;1&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;5&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;[:sr] Ocenite [:en]Rate this [:]post&quot;,&quot;legend&quot;:&quot;5\\\/5 - (1 vote)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;[:sr]Prava mo\u0107 Power pivot tabele[:en]THE REAL POWER OF POWER PIVOT TABLES[:]&quot;,&quot;width&quot;:&quot;142.5&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 142.5px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            5\/5 - (1 vote)    <\/div>\n    <\/div>\n","protected":false},"excerpt":{"rendered":"<p>[:sr]Power pivot (unapre\u0111ena izvedena) tabela obuhvata postupak izrade izve\u0161tajne tabele veoma sli\u010dan Pivot tabeli, \u010dija je osnovna prednost agregiranje\/grupisanje podataka<\/p>\n","protected":false},"author":1,"featured_media":2154,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[43,39],"tags":[],"class_list":["post-913","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-power-excel","category-powerpivot"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>power pivot tabele<\/title>\n<meta name=\"description\" content=\"Power pivot tabele agregiraju podatke koji nisu isklju\u010divo u po\u010detnoj tabeli, nego mogu biti u drugim povezanim tabelama.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kalkulacija.com\/wordpress\/power-pivot-tabele\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"power pivot tabele\" \/>\n<meta property=\"og:description\" content=\"Power pivot tabele agregiraju podatke koji nisu isklju\u010divo u po\u010detnoj tabeli, nego mogu biti u drugim povezanim tabelama.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kalkulacija.com\/wordpress\/power-pivot-tabele\/\" \/>\n<meta property=\"og:site_name\" content=\"Kalkulacija u osnovi svega!\" \/>\n<meta property=\"article:published_time\" content=\"2022-06-13T06:27:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-06-13T11:48:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2021\/06\/power-e1624192014714.png\" \/>\n\t<meta property=\"og:image:width\" content=\"209\" \/>\n\t<meta property=\"og:image:height\" content=\"140\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/power-pivot-tabele\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/power-pivot-tabele\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"headline\":\"[:sr]Prava mo\u0107 Power pivot tabele[:en]THE REAL POWER OF POWER PIVOT TABLES[:]\",\"datePublished\":\"2022-06-13T06:27:16+00:00\",\"dateModified\":\"2022-06-13T11:48:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/power-pivot-tabele\\\/\"},\"wordCount\":1426,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"image\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/power-pivot-tabele\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/power-e1624192014714.png\",\"articleSection\":[\"Power Excel\",\"PowerPivot\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/power-pivot-tabele\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/power-pivot-tabele\\\/\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/power-pivot-tabele\\\/\",\"name\":\"power pivot tabele\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/power-pivot-tabele\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/power-pivot-tabele\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/power-e1624192014714.png\",\"datePublished\":\"2022-06-13T06:27:16+00:00\",\"dateModified\":\"2022-06-13T11:48:58+00:00\",\"description\":\"Power pivot tabele agregiraju podatke koji nisu isklju\u010divo u po\u010detnoj tabeli, nego mogu biti u drugim povezanim tabelama.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/power-pivot-tabele\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/power-pivot-tabele\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/power-pivot-tabele\\\/#primaryimage\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/power-e1624192014714.png\",\"contentUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/power-e1624192014714.png\",\"width\":209,\"height\":140},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/power-pivot-tabele\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Prava mo\u0107 Power pivot tabele\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#website\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/\",\"name\":\"Kalkulacija u osnovi svega!\",\"description\":\"Samo napred! Unapredite svoje ve\u0161tine obrade podataka!\",\"publisher\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"contentUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"width\":128,\"height\":128,\"caption\":\"admin\"},\"logo\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"power pivot tabele","description":"Power pivot tabele agregiraju podatke koji nisu isklju\u010divo u po\u010detnoj tabeli, nego mogu biti u drugim povezanim tabelama.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/kalkulacija.com\/wordpress\/power-pivot-tabele\/","og_locale":"en_US","og_type":"article","og_title":"power pivot tabele","og_description":"Power pivot tabele agregiraju podatke koji nisu isklju\u010divo u po\u010detnoj tabeli, nego mogu biti u drugim povezanim tabelama.","og_url":"https:\/\/kalkulacija.com\/wordpress\/power-pivot-tabele\/","og_site_name":"Kalkulacija u osnovi svega!","article_published_time":"2022-06-13T06:27:16+00:00","article_modified_time":"2022-06-13T11:48:58+00:00","og_image":[{"width":209,"height":140,"url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2021\/06\/power-e1624192014714.png","type":"image\/png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kalkulacija.com\/wordpress\/power-pivot-tabele\/#article","isPartOf":{"@id":"https:\/\/kalkulacija.com\/wordpress\/power-pivot-tabele\/"},"author":{"name":"admin","@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"headline":"[:sr]Prava mo\u0107 Power pivot tabele[:en]THE REAL POWER OF POWER PIVOT TABLES[:]","datePublished":"2022-06-13T06:27:16+00:00","dateModified":"2022-06-13T11:48:58+00:00","mainEntityOfPage":{"@id":"https:\/\/kalkulacija.com\/wordpress\/power-pivot-tabele\/"},"wordCount":1426,"commentCount":0,"publisher":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"image":{"@id":"https:\/\/kalkulacija.com\/wordpress\/power-pivot-tabele\/#primaryimage"},"thumbnailUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2021\/06\/power-e1624192014714.png","articleSection":["Power Excel","PowerPivot"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kalkulacija.com\/wordpress\/power-pivot-tabele\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kalkulacija.com\/wordpress\/power-pivot-tabele\/","url":"https:\/\/kalkulacija.com\/wordpress\/power-pivot-tabele\/","name":"power pivot tabele","isPartOf":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#website"},"primaryImageOfPage":{"@id":"https:\/\/kalkulacija.com\/wordpress\/power-pivot-tabele\/#primaryimage"},"image":{"@id":"https:\/\/kalkulacija.com\/wordpress\/power-pivot-tabele\/#primaryimage"},"thumbnailUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2021\/06\/power-e1624192014714.png","datePublished":"2022-06-13T06:27:16+00:00","dateModified":"2022-06-13T11:48:58+00:00","description":"Power pivot tabele agregiraju podatke koji nisu isklju\u010divo u po\u010detnoj tabeli, nego mogu biti u drugim povezanim tabelama.","breadcrumb":{"@id":"https:\/\/kalkulacija.com\/wordpress\/power-pivot-tabele\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kalkulacija.com\/wordpress\/power-pivot-tabele\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kalkulacija.com\/wordpress\/power-pivot-tabele\/#primaryimage","url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2021\/06\/power-e1624192014714.png","contentUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2021\/06\/power-e1624192014714.png","width":209,"height":140},{"@type":"BreadcrumbList","@id":"https:\/\/kalkulacija.com\/wordpress\/power-pivot-tabele\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kalkulacija.com\/wordpress\/"},{"@type":"ListItem","position":2,"name":"Prava mo\u0107 Power pivot tabele"}]},{"@type":"WebSite","@id":"https:\/\/kalkulacija.com\/wordpress\/#website","url":"https:\/\/kalkulacija.com\/wordpress\/","name":"Kalkulacija u osnovi svega!","description":"Samo napred! Unapredite svoje ve\u0161tine obrade podataka!","publisher":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kalkulacija.com\/wordpress\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","contentUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","width":128,"height":128,"caption":"admin"},"logo":{"@id":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png"}}]}},"_links":{"self":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/913","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/comments?post=913"}],"version-history":[{"count":40,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/913\/revisions"}],"predecessor-version":[{"id":3265,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/913\/revisions\/3265"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/media\/2154"}],"wp:attachment":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/media?parent=913"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/categories?post=913"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/tags?post=913"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}