{"id":2942,"date":"2022-05-16T20:26:56","date_gmt":"2022-05-16T18:26:56","guid":{"rendered":"https:\/\/kalkulacija.com\/wordpress\/?p=2942"},"modified":"2022-05-16T20:53:09","modified_gmt":"2022-05-16T18:53:09","slug":"dax-formule-u-power-pivot-i-power-bi","status":"publish","type":"post","link":"https:\/\/kalkulacija.com\/wordpress\/dax-formule-u-power-pivot-i-power-bi\/","title":{"rendered":"[:sr]DAX formule u Power Pivot i Power BI[:en]DAX formulas in Power Pivot and Power BI[:]"},"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\/dax-formule-u-power-pivot-i-power-bi\/#DAX_formule_u_Power_Pivot_i_Power_BI\" >DAX formule u Power Pivot i Power BI<\/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\/dax-formule-u-power-pivot-i-power-bi\/#DAX_formule_u_Power_Pivot_i_Power_BI-2\" >DAX formule u Power Pivot i Power BI<\/a><\/li><\/ul><\/nav><\/div>\n[:sr]<p><em>DAX (Data Analysis Expressions)<\/em>\u00a0je jezik koji se koristi za kreiranje izraza (formula) radi pravljenja izve\u0161tajnih dimenzija koje se koriste u\u00a0<em>PowerPivot<\/em>\u00a0tabelama. Isti izrazi mogu da se koriste i za tabularni model u okviru re\u0161enja\u00a0<em>MS SQL Server Analysis Services<\/em>. Veliki broj\u00a0<em>DAX<\/em>\u00a0formula ima istu sintaksu kao\u00a0<em>Excel<\/em>\u00a0formule, dok\u00a0neke druge mogu da rade sa relacionim podacima i vr\u0161e dinami\u010dku agregaciju podataka, njihovo filtriranje itd.<\/p>\r\n<h2><span class=\"ez-toc-section\" id=\"DAX_formule_u_Power_Pivot_i_Power_BI\"><\/span>DAX formule u Power Pivot i Power BI<span class=\"ez-toc-section-end\"><\/span><\/h2>\r\n<p>Uvod mo\u017eda deluje zastra\u0161uju\u0107e, ali\u00a0<em>DAX<\/em>\u00a0izrazi se ne razlikuju puno od formula koje ste ranije kreirali u\u00a0<em>Excel<\/em>-u. Njih koristimo radi formiranja:<\/p>\r\n<ul>\r\n<li>izra\u010dunatih kolona (<em>Calculated Columns<\/em>)<\/li>\r\n<li>mera (<em>Measures<\/em>)<\/li>\r\n<\/ul>\r\n<p>Izra\u010dunate kolone u velikoj meri podse\u0107aju na kolone koje dodajemo u strukturiranim tabelama. One su va\u017ene jer ih, osim za kreiranje izve\u0161tajnih dimenzija, mo\u017eemo iskoristiti i za kreiranje\u00a0<em>Slicers<\/em>\u00a0i\u00a0<em>Timeline<\/em>interaktivnih filtera.<\/p>\r\n<p>Mere su formule koje se pi\u0161u direktno u modelu, a mo\u017eemo da ih iskoristimo za kreiranje znatno slo\u017eenijih izve\u0161tajnih dimenzija. U verziji 2013 mere su se jo\u0161 nazivale i izra\u010dunatim poljima (<em>Calculated Fields<\/em>), a od verzije 2016 ponovo se nazivaju mere (<em>Measures<\/em>).<\/p>\r\n<p>Pored mera koje smo sami napravili (eksplicitne mere), postoje i implicitne mere koje se automatski generi\u0161u prevla\u010denjem izve\u0161tanih dimenzija u polja za agregaciju podataka. Na primer, prevla\u010denjem dimenzije KOL u polje za agregaciju podataka (<em>Values<\/em>) implicitno se kreira mera SUM of KOL. Od verzije 2016 postoji mogu\u0107nost da se i implicitne mere vide u modelu. To posti\u017eemo klikom na dugme\u00a0<em>Show Implicit Measures<\/em>\u00a0u\u00a0<em>Advanced<\/em>\u00a0traci alata.<\/p>\r\n<p>Hajde da kreiramo dva jednostavna\u00a0<em>DAX<\/em>\u00a0izraza! Klikom na dugme\u00a0<em>Manage<\/em>\u00a0u\u00a0<em>Power Pivot<\/em>\u00a0traci alata otvaramo prozor Modela podataka, a zatim treba da se pozicioniramo na onu tabelu (neka od tabela koju smo prethodno dodali u Model) u kojoj \u017eelimo da kreiramo izra\u010dunate kolone ili mere.<\/p>\r\n<p>Ako dodajemo izra\u010dunatu kolonu treba da kliknemo ispod oznake\u00a0<em>Add Column<\/em>, sa krajnje desne strane tabele. Zatim u polju za unos formula upisujemo formulu tako \u0161to je zapo\u010dinjemo znakom \u201e=\u201c, a zatim ispisujemo\u00a0<em>DAX<\/em>\u00a0izraz. Prilikom pisanja formula pokre\u0107e se mehanizam poznat kao\u00a0<em>Intellisense<\/em>\u00a0koji nam automatski nudi nazive kolona ili\u00a0<em>DAX<\/em>\u00a0formule koje mo\u017eemo da iskoristimo za kreiranje izraza, \u0161to zna\u010dajno upro\u0161\u0107ava proces njihovog pisanja. U na\u0161em primeru odabrali smo tabelu Artikli \u017eelimo da kreiramo izraz koji prodajnu cenu deli sa kursem EUR:=[PC]\/120<\/p>\r\n<p>Nakon \u0161to smo uneli formulu nova kolona\u00a0\u0107e se automatski popuniti izra\u010dunatim vrednostima. Ona dobija privremeno ime\u00a0<em>CalculatedColumn&lt;n&gt;<\/em>\u00a0(n je neki ceo broj). Po\u0161to ovo ime nije prikladno, promeni\u0107emo ga tako \u0161to \u0107emo da kliknemo desnim tasterom mi\u0161a na naziv kolone i u kontestnom meniju izaberemo opciju\u00a0<em>Rename Column<\/em>. Zaglavlje kolone \u0107e promeniti boju i mo\u017eemo da unesemo neko prikladnije ime, npr. \u201ePC (EUR)\u201c. U ovom meniju postoji jo\u0161 nekoliko opcija za manipulaciju izra\u010dunatim kolonama, koje npr. mo\u017eemo da sakrijemo, zamrznemo, promenimo im \u0161irinu ili redosled\u2026<\/p>\r\n<p>Bilo da pravimo izra\u010dunate kolone ilimere, odmah nakon \u0161to ih napravimo, treba da odredimo na\u010din prikaza njihovog sadr\u017eaja (formatiranje). To \u0107emo najlak\u0161e da u\u010dinimo tako \u0161to odemo na\u00a0<em>Home<\/em>\u00a0traku alata, pa u odeljku\u00a0<em>Formatting<\/em>\u00a0izaberemo neku od opcija za formatiranje (General, Decimal, Percent, Currency etc.).. Osnovno formatiranje koje dobija svaka formula nakon svog nastanka je\u00a0<em>General<\/em>, \u0161to mo\u017eemo da vidimo kada selektujemo izra\u010dunatu kolonu ili meru. U zavisnosti od sadr\u017eaja formule dalje im dodeljujemo \u017eeljeni format. Na primer, malopre kreiranu izra\u010dunatu kolonu \u201ePC (EUR)\u201c mo\u017eemo da formatiramo kao decimalan broj sa dve decimale.<\/p>\r\n<p>Mere mo\u017eemo da napravimo\u00a0na dva na\u010dina. Prvi na\u010din bio bi da kliknemo u polje ispod tabele sa podacima (<em>Calculation Area<\/em>), u nekoj od tabela gde \u017eelimo da kreiramo meru. Zatim navodimo naziv mere, pa simbol \u201e:=\u201c, a na kraju pi\u0161emo \u017eeljeni\u00a0<em>DAX<\/em>\u00a0izraz. Na primer, ako se pozicioniramo na tabelu Transakcije\u00a0mo\u017eemo da napravimo meru koja sumira sve prodate koli\u010dine: <strong>SumaKolicina:=SUM([KOL])<\/strong><\/p>\r\n<p>Drugi na\u010din za kreiranje mera je pomo\u0107u opcije\u00a0<em>New Measure<\/em>, koja se nalazi u meniju\u00a0<em>Measures\u00a0<\/em>u\u00a0<em>Power Pivot<\/em>\u00a0traci alata. Nakon \u0161to je pokrenemo otvori\u0107e se dijalog prozor u \u010dijem zaglavlju najpre unosimo naziv tabele\u00a0u kojoj\u00a0kreiramo meru (<em>Table Name<\/em>), a zatim ime mere (<em>Measure\u00a0name<\/em>). Na kraju u centralnom delu prozora unosimo i\u00a0<em>DAX<\/em>\u00a0izraz. Tokom unosa formulu mo\u017eemo da testiramo, a mo\u017eemo i da odredimo format prikaza broja. Nakon \u0161to unesemo ispravnu formulu mera koju smo kreirali pojavi\u0107e se u zadatoj tabeli Modela podataka. U meniju\u00a0<em>Measures<\/em>\u00a0nalazi se jo\u0161 i opcija\u00a0<em>Manage Measures<\/em>, pomo\u0107u koje mo\u017eemo da\u00a0menjamo prethodno kreirane mere.<\/p>\r\n<p>Ako bi smo sada izabrali\u00a0Pivot tabelu (<em>Power Pivot<\/em>),\u00a0koju smo napravili\u00a0na osnovu ovog Modela podataka, videli bi smo dve nove izve\u0161tajne dimenzije: dodatu izra\u010dunatu kolonu \u201ePC (EUR)\u201c i meru sa nazivom \u201eSumaKolicina\u201c.<\/p>\r\n<p>Izvori:<\/p>\r\n<ol>\r\n<li><a href=\"https:\/\/data-flair.training\/blogs\/power-bi-dax-basics\/\" target=\"_blank\" rel=\"noopener\">https:\/\/data-flair.training\/blogs\/power-bi-dax-basics\/<\/a><\/li>\r\n<li><a href=\"https:\/\/www.myonlinetraininghub.com\/introduction-to-dax-measures\" target=\"_blank\" rel=\"noopener\">https:\/\/www.myonlinetraininghub.com\/introduction-to-dax-measures<\/a><\/li>\r\n<li><a href=\"https:\/\/www.lightdotlab.com\/blog\/2018\/power-series-way-part-2-power-pivot-data-model-dax\" target=\"_blank\" rel=\"noopener\">https:\/\/www.lightdotlab.com\/blog\/2018\/power-series-way-part-2-power-pivot-data-model-dax<\/a><\/li>\r\n<li><a href=\"https:\/\/kalkulacija.com\/wordpress\/dax-formule-u-power-pivot-power-bi-i-power-query-dodacima\/\" target=\"_blank\" rel=\"noopener\">https:\/\/exceltown.com\/en\/tutorials\/power-bi\/powerbi-com-and-power-bi-desktop\/dax-query-language-for-power-bi-and-power-pivot\/<\/a><\/li>\r\n<li><a href=\"https:\/\/support.microsoft.com\/en-us\/office\/data-analysis-expressions-dax-in-power-pivot-bab3fbe3-2385-485a-980b-5f64d3b0f730\" target=\"_blank\" rel=\"noopener\">https:\/\/support.microsoft.com\/en-us\/office\/data-analysis-expressions-dax-in-power-pivot-bab3fbe3-2385-485a-980b-5f64d3b0f730<\/a><\/li>\r\n<li><a href=\"https:\/\/www.kscpa.org\/event\/CXOPBI207W4-28948\" target=\"_blank\" rel=\"noopener\">https:\/\/www.kscpa.org\/event\/CXOPBI207W4-28948<\/a><\/li>\r\n<li><a href=\"https:\/\/blog.enterprisedna.co\/predict-profitability-for-future-time-periods-with-power-bi-techniques\/\" target=\"_blank\" rel=\"noopener\">https:\/\/blog.enterprisedna.co\/predict-profitability-for-future-time-periods-with-power-bi-techniques\/<\/a><\/li>\r\n<li><a href=\"https:\/\/towardsdatascience.com\/why-is-dax-difficult-to-learn-4fc792d6f801\" target=\"_blank\" rel=\"noopener\">https:\/\/towardsdatascience.com\/why-is-dax-difficult-to-learn-4fc792d6f801<\/a><\/li>\r\n<li><a href=\"https:\/\/www.sqlbi.com\/articles\/hiding-future-dates-for-calculations-in-dax\/\" target=\"_blank\" rel=\"noopener\">https:\/\/www.sqlbi.com\/articles\/hiding-future-dates-for-calculations-in-dax\/<\/a><\/li>\r\n<li><a href=\"https:\/\/towardsdatascience.com\/power-bi-what-is-dax-and-why-you-should-or-should-not-learn-it-1581aadbb038\" target=\"_blank\" rel=\"noopener\">https:\/\/towardsdatascience.com\/power-bi-what-is-dax-and-why-you-should-or-should-not-learn-it-1581aadbb038<\/a><\/li>\r\n<li><a href=\"https:\/\/go.christiansteven.com\/bi-blog\/power-bi\/what-is-dax-what-are-the-benefits-of-using-variables-in-dax\" target=\"_blank\" rel=\"noopener\">https:\/\/go.christiansteven.com\/bi-blog\/power-bi\/what-is-dax-what-are-the-benefits-of-using-variables-in-dax<\/a><\/li>\r\n<li><a href=\"https:\/\/curbal.com\/25-days-of-dax-fridays-challenge\" target=\"_blank\" rel=\"noopener\">https:\/\/curbal.com\/25-days-of-dax-fridays-challenge<\/a><\/li>\r\n<\/ol>\r\n<p>&nbsp;<\/p>\r\n[:en]<p><em><span>DAX (Data Analysis Expressions)<\/span><\/em><span>\u00a0\u00a0is a language used to create expressions (formulas) to create reporting dimensions used in\u00a0\u00a0<\/span><em><span>PowerPivot<\/span><\/em><span>\u00a0\u00a0tables.\u00a0The same terms can be used for the tabular model within\u00a0\u00a0<\/span><em><span>MS SQL Server Analysis Services<\/span><\/em><span>\u00a0.\u00a0Many\u00a0\u00a0<\/span><em><span>DAX<\/span><\/em><span>\u00a0\u00a0formulas have the same syntax as\u00a0\u00a0<\/span><em><span>Excel<\/span><\/em><span>\u00a0\u00a0formulas, while some others can work with relational data and perform dynamic data aggregation, filtering, etc.<\/span><\/p>\r\n<h2><span class=\"ez-toc-section\" id=\"DAX_formule_u_Power_Pivot_i_Power_BI-2\"><\/span><span id=\"DAX_formule_u_Power_Pivot_i_Power_BI\" class=\"ez-toc-section\"><\/span><span>DAX formule u Power Pivot i Power BI<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\r\n<p><span>The introduction may seem intimidating, but\u00a0\u00a0<\/span><em><span>DAX<\/span><\/em><span>\u00a0\u00a0expressions are not much different from formulas you created earlier in\u00a0\u00a0<\/span><em><span>Excel<\/span><\/em><span>\u00a0.\u00a0We use them to form:<\/span><\/p>\r\n<ul>\r\n<li><span>Calculated\u00a0<\/span><em><span>Columns<\/span><\/em><span>\u00a0_<\/span><\/li>\r\n<li>mera (<em>Measures<\/em>)<\/li>\r\n<\/ul>\r\n<p><span>The calculated columns are very similar to the columns we add in structured tables.\u00a0They are important because, in addition to creating report dimensions, we can also use them to create\u00a0\u00a0<\/span><em><span>Slicers<\/span><\/em><span>\u00a0\u00a0and\u00a0\u00a0<\/span><em><span>Timeline<\/span><\/em><span>\u00a0interactive filters.<\/span><\/p>\r\n<p><span>Measures are formulas that are written directly in the model, and we can use them to create much more complex reporting dimensions.\u00a0In the 2013 version, the measures were also called\u00a0<\/span><em><span>Calculated Fields<\/span><\/em><span>\u00a0, and since the 2016 version, they have been called\u00a0<\/span><em><span>Measures<\/span><\/em><span>\u00a0again .<\/span><\/p>\r\n<p><span>In addition to the measures we have made ourselves (explicit measures), there are also implicit measures that are automatically generated by dragging the reported dimensions into the data aggregation fields.\u00a0For example, dragging the KOL dimension into the\u00a0<\/span><em><span>Values<\/span><\/em><span>\u00a0\u200b\u200bfield aggregation implicitly creates a SUM of KOL measure.\u00a0As of the 2016 version, there is a possibility that implicit measures can be seen in the model.\u00a0We achieve this by clicking the\u00a0\u00a0<\/span><em><span>Show Implicit Measures<\/span><\/em><span>\u00a0button \u00a0in the\u00a0\u00a0<\/span><em><span>Advanced<\/span><\/em><span>\u00a0\u00a0toolbar.<\/span><\/p>\r\n<p><span>Let&#8217;s create two simple\u00a0\u00a0<\/span><em><span>DAX<\/span><\/em><span>\u00a0\u00a0expressions!\u00a0<\/span><em><span>Clicking the Manage<\/span><\/em><span>\u00a0button\u00a0\u00a0\u00a0in the\u00a0\u00a0<\/span><em><span>Power Pivot<\/span><\/em><span>\u00a0\u00a0toolbar opens the Data Model window, and then we need to position ourselves on the table (some of the tables we previously added to the Model) in which we want to create calculated columns or measures.<\/span><\/p>\r\n<p><span>If we are adding a calculated column, we need to click under the\u00a0\u00a0<\/span><em><span>Add Column<\/span><\/em><span>\u00a0label , on the far right side of the table.\u00a0Then, in the formula entry field, enter the formula by starting it with the &#8220;=&#8221; sign, and then print the\u00a0\u00a0<\/span><em><span>DAX<\/span><\/em><span>\u00a0\u00a0expression.\u00a0When writing formulas, a mechanism known as\u00a0\u00a0<\/span><em><span>Intellisense<\/span><\/em><span>\u00a0is launched \u00a0that automatically offers us column names or\u00a0\u00a0<\/span><em><span>DAX<\/span><\/em><span>\u00a0\u00a0formulas that we can use to create expressions, which greatly simplifies the process of writing them.\u00a0In our example we have selected the table Items we want to create an expression that divides the selling price by the exchange rate EUR: = [PC] \/ 120<\/span><\/p>\r\n<p><span>After we have entered the formula, the new column will be automatically filled with the calculated values.\u00a0It is given the temporary name\u00a0\u00a0<\/span><em><span>CalculatedColumn<\/span><\/em><span>\u00a0\u00a0(n is an integer).\u00a0Since this name is not appropriate, we will change it by right-clicking on the column name and selecting the\u00a0\u00a0<\/span><em><span>Rename Column<\/span><\/em><span>\u00a0option in the context menu .\u00a0The column header will change color and we can enter a more appropriate name, e.g.\u00a0&#8220;PC (EUR)&#8221;.\u00a0In this menu, there are several other options for manipulating the calculated columns, which e.g.\u00a0we can hide, freeze, change their width or order\u2026<\/span><\/p>\r\n<p><span>Whether we make calculated columns of ilimers, immediately after we make them, we need to determine how to display their content (formatting).\u00a0The easiest way to do this is to go to the\u00a0\u00a0<\/span><em><span>Home<\/span><\/em><span>\u00a0\u00a0toolbar, and in the\u00a0\u00a0<\/span><em><span>Formatting<\/span><\/em><span>\u00a0section, \u00a0select one of the formatting options (General, Decimal, Percent, Currency, etc.). The basic formatting that each formula receives after its creation is\u00a0\u00a0<\/span><em><span>General<\/span><\/em><span>\u00a0, which we can to see when we select a calculated column or measure.\u00a0Depending on the content of the formula, we further assign them the desired format.\u00a0For example, a newly created calculated column &#8220;PC (EUR)&#8221; can be formatted as a decimal number with two decimal places.<\/span><\/p>\r\n<p><span>We can take measures in two ways.\u00a0The first way would be to click in the field below the\u00a0<\/span><em><span>Calculation Area<\/span><\/em><span>\u00a0table, in one of the tables where we want to create a measure.\u00a0Then we state the name of the measure, then the symbol &#8220;: =&#8221;, and at the end we write the desired\u00a0\u00a0<\/span><em><span>DAX<\/span><\/em><span>\u00a0\u00a0expression.\u00a0For example, if we position ourselves on the Transaction table, we can create a measure that summarizes all quantities sold:\u00a0<\/span><strong><span>AmountQuantity: = AMOUNT ([KOL])<\/span><\/strong><\/p>\r\n<p><span>Another way to create measures is by using the\u00a0\u00a0<\/span><em><span>New Measure<\/span><\/em><span>\u00a0option , which is located in the\u00a0\u00a0<\/span><em><span>Measures\u00a0<\/span><\/em><span>\u00a0menu in\u00a0 the\u00a0<\/span><em><span>Power Pivot<\/span><\/em><span>\u00a0\u00a0toolbar.\u00a0After launching it, a dialog box will open in the header of which we first enter the name of the table in which we create the measure (\u00a0<\/span><em><span>Table Name<\/span><\/em><span>\u00a0), and then the name of the measure (\u00a0<\/span><em><span>Measure name<\/span><\/em><span>\u00a0).\u00a0Finally, in the central part of the window, enter the\u00a0\u00a0<\/span><em><span>DAX<\/span><\/em><span>\u00a0\u00a0expression.\u00a0During input, we can test the formula, and we can also specify the number display format.\u00a0After we enter the correct formula of the measures we have created, it will appear in the given table of the Data Model.\u00a0<\/span><em><span>The Measures<\/span><\/em><span>\u00a0menu\u00a0 also includes the\u00a0<em>Manage Measures<\/em>\u00a0\u00a0option\u00a0<\/span><span>, with which we can change previously created measures.<\/span><\/p>\r\n<p><span>If we now chose the Pivot Table (\u00a0<\/span><em><span>Power Pivot<\/span><\/em><span>\u00a0), which we created based on this Data Model, we would see two new reporting dimensions: the added calculated column &#8220;PC (EUR)&#8221; and the measure called &#8220;AmountQuantity&#8221;.<\/span><\/p>\r\n<p><span>Sources:<\/span><\/p>\r\n<ol>\r\n<li><a href=\"https:\/\/data-flair.training\/blogs\/power-bi-dax-basics\/\" target=\"_blank\" rel=\"noopener\">https:\/\/data-flair.training\/blogs\/power-bi-dax-basics\/<\/a><\/li>\r\n<li><a href=\"https:\/\/www.myonlinetraininghub.com\/introduction-to-dax-measures\" target=\"_blank\" rel=\"noopener\">https:\/\/www.myonlinetraininghub.com\/introduction-to-dax-measures<\/a><\/li>\r\n<li><a href=\"https:\/\/www.lightdotlab.com\/blog\/2018\/power-series-way-part-2-power-pivot-data-model-dax\" target=\"_blank\" rel=\"noopener\">https:\/\/www.lightdotlab.com\/blog\/2018\/power-series-way-part-2-power-pivot-data-model-dax<\/a><\/li>\r\n<li><a href=\"https:\/\/kalkulacija.com\/wordpress\/dax-formule-u-power-pivot-power-bi-i-power-query-dodacima\/\" target=\"_blank\" rel=\"noopener\">https:\/\/exceltown.com\/en\/tutorials\/power-bi\/powerbi-com-and-power-bi-desktop\/dax-query-language-for-power-bi-and-power-pivot\/<\/a><\/li>\r\n<li><a href=\"https:\/\/support.microsoft.com\/en-us\/office\/data-analysis-expressions-dax-in-power-pivot-bab3fbe3-2385-485a-980b-5f64d3b0f730\" target=\"_blank\" rel=\"noopener\">https:\/\/support.microsoft.com\/en-us\/office\/data-analysis-expressions-dax-in-power-pivot-bab3fbe3-2385-485a-980b-5f64d3b0f730<\/a><\/li>\r\n<li><a href=\"https:\/\/www.kscpa.org\/event\/CXOPBI207W4-28948\" target=\"_blank\" rel=\"noopener\">https:\/\/www.kscpa.org\/event\/CXOPBI207W4-28948<\/a><\/li>\r\n<li><a href=\"https:\/\/blog.enterprisedna.co\/predict-profitability-for-future-time-periods-with-power-bi-techniques\/\" target=\"_blank\" rel=\"noopener\">https:\/\/blog.enterprisedna.co\/predict-profitability-for-future-time-periods-with-power-bi-techniques\/<\/a><\/li>\r\n<li><a href=\"https:\/\/towardsdatascience.com\/why-is-dax-difficult-to-learn-4fc792d6f801\" target=\"_blank\" rel=\"noopener\">https:\/\/towardsdatascience.com\/why-is-dax-difficult-to-learn-4fc792d6f801<\/a><\/li>\r\n<li><a href=\"https:\/\/www.sqlbi.com\/articles\/hiding-future-dates-for-calculations-in-dax\/\" target=\"_blank\" rel=\"noopener\">https:\/\/www.sqlbi.com\/articles\/hiding-future-dates-for-calculations-in-dax\/<\/a><\/li>\r\n<li><a href=\"https:\/\/towardsdatascience.com\/power-bi-what-is-dax-and-why-you-should-or-should-not-learn-it-1581aadbb038\" target=\"_blank\" rel=\"noopener\">https:\/\/towardsdatascience.com\/power-bi-what-is-dax-and-why-you-should-or-should-not-learn-it-1581aadbb038<\/a><\/li>\r\n<li><a href=\"https:\/\/go.christiansteven.com\/bi-blog\/power-bi\/what-is-dax-what-are-the-benefits-of-using-variables-in-dax\" target=\"_blank\" rel=\"noopener\">https:\/\/go.christiansteven.com\/bi-blog\/power-bi\/what-is-dax-what-are-the-benefits-of-using-variables-in-dax<\/a><\/li>\r\n<li><a href=\"https:\/\/curbal.com\/25-days-of-dax-fridays-challenge\" target=\"_blank\" rel=\"noopener\">https:\/\/curbal.com\/25-days-of-dax-fridays-challenge<\/a><\/li>\r\n<\/ol>\r\n\r\n\r\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;2942&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;0&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;0&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;0\\\/5 - (0 votes)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;[:sr]DAX formule u Power Pivot i Power BI[:en]DAX formulas in Power Pivot and Power BI[:]&quot;,&quot;width&quot;:&quot;0&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: 0px;\">\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            <span class=\"kksr-muted\">[:sr] Ocenite [:en]Rate this [:]post<\/span>\n    <\/div>\n    <\/div>\n","protected":false},"excerpt":{"rendered":"<p>[:sr] DAX (Data Analysis Expressions)\u00a0je jezik koji se koristi za kreiranje izraza (formula) radi pravljenja izve\u0161tajnih dimenzija koje se koriste<\/p>\n","protected":false},"author":1,"featured_media":3036,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[43,41,39,40],"tags":[],"class_list":["post-2942","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-power-excel","category-powerbi","category-powerpivot","category-powerquery"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>DAX formule u Power Pivot i Power BI<\/title>\n<meta name=\"description\" content=\"DAX formule u Power Pivot I Power BI omogu\u0107avaju rad sa bigdata sistemima i velikim bazama podataka direktno.\" \/>\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\/dax-formule-u-power-pivot-i-power-bi\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"DAX formule u Power Pivot i Power BI\" \/>\n<meta property=\"og:description\" content=\"DAX formule u Power Pivot I Power BI omogu\u0107avaju rad sa bigdata sistemima i velikim bazama podataka direktno.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kalkulacija.com\/wordpress\/dax-formule-u-power-pivot-i-power-bi\/\" \/>\n<meta property=\"og:site_name\" content=\"Kalkulacija u osnovi svega!\" \/>\n<meta property=\"article:published_time\" content=\"2022-05-16T18:26:56+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-05-16T18:53:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/05\/dax.png\" \/>\n\t<meta property=\"og:image:width\" content=\"960\" \/>\n\t<meta property=\"og:image:height\" content=\"969\" \/>\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\\\/dax-formule-u-power-pivot-i-power-bi\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/dax-formule-u-power-pivot-i-power-bi\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"headline\":\"[:sr]DAX formule u Power Pivot i Power BI[:en]DAX formulas in Power Pivot and Power BI[:]\",\"datePublished\":\"2022-05-16T18:26:56+00:00\",\"dateModified\":\"2022-05-16T18:53:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/dax-formule-u-power-pivot-i-power-bi\\\/\"},\"wordCount\":1874,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"image\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/dax-formule-u-power-pivot-i-power-bi\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/dax.png\",\"articleSection\":[\"Power Excel\",\"PowerBI\",\"PowerPivot\",\"PowerQuery\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/dax-formule-u-power-pivot-i-power-bi\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/dax-formule-u-power-pivot-i-power-bi\\\/\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/dax-formule-u-power-pivot-i-power-bi\\\/\",\"name\":\"DAX formule u Power Pivot i Power BI\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/dax-formule-u-power-pivot-i-power-bi\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/dax-formule-u-power-pivot-i-power-bi\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/dax.png\",\"datePublished\":\"2022-05-16T18:26:56+00:00\",\"dateModified\":\"2022-05-16T18:53:09+00:00\",\"description\":\"DAX formule u Power Pivot I Power BI omogu\u0107avaju rad sa bigdata sistemima i velikim bazama podataka direktno.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/dax-formule-u-power-pivot-i-power-bi\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/dax-formule-u-power-pivot-i-power-bi\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/dax-formule-u-power-pivot-i-power-bi\\\/#primaryimage\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/dax.png\",\"contentUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/dax.png\",\"width\":960,\"height\":969,\"caption\":\"DAX formule u Power Pivot i Power BI\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/dax-formule-u-power-pivot-i-power-bi\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"DAX formule u Power Pivot i Power BI\"}]},{\"@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":"DAX formule u Power Pivot i Power BI","description":"DAX formule u Power Pivot I Power BI omogu\u0107avaju rad sa bigdata sistemima i velikim bazama podataka direktno.","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\/dax-formule-u-power-pivot-i-power-bi\/","og_locale":"en_US","og_type":"article","og_title":"DAX formule u Power Pivot i Power BI","og_description":"DAX formule u Power Pivot I Power BI omogu\u0107avaju rad sa bigdata sistemima i velikim bazama podataka direktno.","og_url":"https:\/\/kalkulacija.com\/wordpress\/dax-formule-u-power-pivot-i-power-bi\/","og_site_name":"Kalkulacija u osnovi svega!","article_published_time":"2022-05-16T18:26:56+00:00","article_modified_time":"2022-05-16T18:53:09+00:00","og_image":[{"width":960,"height":969,"url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/05\/dax.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\/dax-formule-u-power-pivot-i-power-bi\/#article","isPartOf":{"@id":"https:\/\/kalkulacija.com\/wordpress\/dax-formule-u-power-pivot-i-power-bi\/"},"author":{"name":"admin","@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"headline":"[:sr]DAX formule u Power Pivot i Power BI[:en]DAX formulas in Power Pivot and Power BI[:]","datePublished":"2022-05-16T18:26:56+00:00","dateModified":"2022-05-16T18:53:09+00:00","mainEntityOfPage":{"@id":"https:\/\/kalkulacija.com\/wordpress\/dax-formule-u-power-pivot-i-power-bi\/"},"wordCount":1874,"commentCount":0,"publisher":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"image":{"@id":"https:\/\/kalkulacija.com\/wordpress\/dax-formule-u-power-pivot-i-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/05\/dax.png","articleSection":["Power Excel","PowerBI","PowerPivot","PowerQuery"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kalkulacija.com\/wordpress\/dax-formule-u-power-pivot-i-power-bi\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kalkulacija.com\/wordpress\/dax-formule-u-power-pivot-i-power-bi\/","url":"https:\/\/kalkulacija.com\/wordpress\/dax-formule-u-power-pivot-i-power-bi\/","name":"DAX formule u Power Pivot i Power BI","isPartOf":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#website"},"primaryImageOfPage":{"@id":"https:\/\/kalkulacija.com\/wordpress\/dax-formule-u-power-pivot-i-power-bi\/#primaryimage"},"image":{"@id":"https:\/\/kalkulacija.com\/wordpress\/dax-formule-u-power-pivot-i-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/05\/dax.png","datePublished":"2022-05-16T18:26:56+00:00","dateModified":"2022-05-16T18:53:09+00:00","description":"DAX formule u Power Pivot I Power BI omogu\u0107avaju rad sa bigdata sistemima i velikim bazama podataka direktno.","breadcrumb":{"@id":"https:\/\/kalkulacija.com\/wordpress\/dax-formule-u-power-pivot-i-power-bi\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kalkulacija.com\/wordpress\/dax-formule-u-power-pivot-i-power-bi\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kalkulacija.com\/wordpress\/dax-formule-u-power-pivot-i-power-bi\/#primaryimage","url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/05\/dax.png","contentUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/05\/dax.png","width":960,"height":969,"caption":"DAX formule u Power Pivot i Power BI"},{"@type":"BreadcrumbList","@id":"https:\/\/kalkulacija.com\/wordpress\/dax-formule-u-power-pivot-i-power-bi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kalkulacija.com\/wordpress\/"},{"@type":"ListItem","position":2,"name":"DAX formule u Power Pivot i Power BI"}]},{"@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\/2942","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=2942"}],"version-history":[{"count":8,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/2942\/revisions"}],"predecessor-version":[{"id":3038,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/2942\/revisions\/3038"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/media\/3036"}],"wp:attachment":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/media?parent=2942"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/categories?post=2942"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/tags?post=2942"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}