{"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\/en\/power-pivot-tabele\/","title":{"rendered":"THE REAL POWER OF POWER PIVOT TABLES"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_83 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\">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\/en\/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\/en\/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\/en\/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\/en\/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\/en\/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\/en\/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\/en\/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\/en\/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\/en\/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\/en\/power-pivot-tabele\/#Application_of_DAX_formula\" >Application of DAX formula<\/a><\/li><\/ul><\/nav><\/div>\n<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_1778562059\">\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_1778562059\" 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=\"beb21ae5f4\" 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_1778562059\"><\/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;Rate this post&quot;,&quot;legend&quot;:&quot;5\\\/5 - (1 vote)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;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>","protected":false},"excerpt":{"rendered":"<p>Power pivot (advanced derived) table includes the process of creating a report table very similar to\u00a0the Pivot table\u00a0, whose main<\/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 v27.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=\"Calculation in essence of everything!\" \/>\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\":\"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\":\"Calculation in essence of everything!\",\"description\":\"Go ahead! Improve your data processing skills!\",\"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":"Calculation in essence of everything!","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":"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":"Calculation in essence of everything!","description":"Go ahead! Improve your data processing skills!","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\/en\/wp-json\/wp\/v2\/posts\/913","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/comments?post=913"}],"version-history":[{"count":40,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/posts\/913\/revisions"}],"predecessor-version":[{"id":3265,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/posts\/913\/revisions\/3265"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/media\/2154"}],"wp:attachment":[{"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/media?parent=913"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/categories?post=913"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/tags?post=913"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}