{"id":2109,"date":"2023-10-15T16:51:36","date_gmt":"2023-10-15T16:51:36","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/perbedaan-tanggal\/"},"modified":"2023-12-06T06:16:17","modified_gmt":"2023-12-06T06:16:17","slug":"perbedaan-tanggal","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/perbedaan-tanggal\/","title":{"rendered":"Bagaimana cara mendapatkan perbedaan tanggal di power query?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3067175968\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Dengan Power Query, Anda bisa mendapatkan perbedaan antara dua tanggal di Excel. Dan dalam tutorial ini, kita akan mempelajarinya secara detail. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88797\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-difference-entre-deux-dates-dans-la-requete-de-puissance.png\" sizes=\"auto, \" srcset=\"\" alt=\"perbedaan-antara-dua-tanggal-dalam-kuasa-kueri\" width=\"314\" height=\"97\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Hitung hari antara dua tanggal<\/h2><ol><li> Mulailah dengan membuka data Anda di editor kueri yang canggih (tab Data &gt; Dapatkan Data &gt; Dari Sumber Lain &gt; Dari Tabel\/Rentang. <br><img loading=\"lazy\" decoding=\"async\" title=\"Hitungan 2 hari antara dua hari\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-compter-les-jours-entre-deux-jours.png\" sizes=\"auto, \" srcset=\"\" alt=\"count-days-between-two-days\" width=\"508\" height=\"434\"><\/li><li> Setelah itu, buka Tambahkan Kolom &gt; Kolom Kustom. <br><img loading=\"lazy\" decoding=\"async\" title=\"3-buka-tambah-kolom-dan-lalu-kolom-kustom\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-allez-ajouter-des-colonnes-puis-des-colonnes-personnalisees.png\" sizes=\"auto, \" srcset=\"\" alt=\"go-to-add-columns-and-then-custom-columns\" width=\"600\" height=\"259\"><\/li><li> Sekarang di kotak dialog Kolom Kustom, beri nama kolom kustom baru dan masukkan rumus (Durasi.Hari([Tanggal 2]-[Tanggal 1])). <br><img loading=\"lazy\" decoding=\"async\" title=\"4-nama-kolom-kustom-baru-dan-masukkan-rumus\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-nommez-la-nouvelle-colonne-personnalisee-et-entrez-la-formule.png\" sizes=\"auto, \" srcset=\"\" alt=\"name-new-custom-column-and-enter-formula\" width=\"614\" height=\"384\"><\/li><li> Pada akhirnya, klik OK untuk menyisipkan kolom kustom baru. <br><img loading=\"lazy\" decoding=\"async\" title=\"5-klik-ok-untuk-memasukkan-kolom-kustom-baru\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-cliquez-sur-ok-pour-inserer-une-nouvelle-colonne-personnalisee.png\" sizes=\"auto, \" srcset=\"\" alt=\"click-ok-to-insert-new-custom-column\" width=\"561\" height=\"123\"><\/li><\/ol><p> Dalam rumus ini, kita mengurangi tanggal 1 dari tanggal 2 dan kemudian menggunakan fungsi Duration.Days untuk mendapatkan jumlah hari.<\/p><p> Bahkan Anda bisa mendapatkan jumlah hari menggunakan fungsi Duration.Days. Anda dapat menyimpulkan tanggal 1 dari tanggal 2, seperti pada contoh berikut. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88802\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-deduire-date1-de-date2.png\" sizes=\"auto, \" srcset=\"\" alt=\"menyimpulkan-tanggal1-dari-tanggal2\" width=\"644\" height=\"237\"><\/figure><\/div><pre class=\"wp-block-preformatted\"> =[Date 2]-[Date 1]<\/pre><p> Dan setelah Anda mengklik OK, itu akan mengembalikan hitungan di kolom kustom baru. Namun Anda perlu mengubah format kolom menjadi bilangan bulat untuk menghapus format desimal. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88803\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-changer-le-format-de-la-colonne-en-nombre-entier.png\" sizes=\"auto, \" srcset=\"\" alt=\"ubah-format-kolom-menjadi-bilangan bulat\" width=\"700\" height=\"342\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Perbedaan tanggal dengan tanggal hari ini<\/h2><p> Dan jika Anda ingin mendapatkan selisihnya dengan menggunakan tanggal hari ini, Anda perlu menggunakan rumus yang sedikit berbeda dari sebelumnya. <\/p><pre class=\"wp-block-preformatted\"> = DateTime.Date( DateTime.LocalNow() )-[Date 1] <\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88804\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-difference-de-date-par-rapport-a-la-date-daujourdhui.png\" sizes=\"auto, \" srcset=\"\" alt=\"perbedaan-tanggal-dengan-tanggal hari ini\" width=\"648\" height=\"345\"><\/figure><\/div><p> Rumus ini mendapatkan tanggal hari ini dan menyimpulkan tanggal yang Anda tentukan. Dan setelah Anda mengklik OK, kolom baru akan disisipkan dengan selisih tanggal. Dan Anda dapat mengubah rumus kolom penghitungan hari menjadi bilangan bulat. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88805\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-nouvelle-colonne-avec-la-difference-entre-les-dates.png\" sizes=\"auto, \" srcset=\"\" alt=\"kolom-baru-dengan-perbedaan-antara-tanggal\" width=\"626\" height=\"324\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Dapatkan jumlah bulan di antara tanggal<\/h2><p> Dan dibawah ini adalah rumus yang bisa anda gunakan untuk mendapatkan jumlah bulan diantara dua hari.<\/p><pre class=\"wp-block-preformatted\"> =((Date.Year([Date 2])-Date.Year([Date 1]))*12) + Date.Month([Date 2]) - Date.Month([Date 1])<\/pre><p> Rumus ini akan mengembalikan jumlah total bulan penuh antara dua tanggal pada hasil. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88806\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-nombre-de-mois-entre-les-dates.png\" sizes=\"auto, \" srcset=\"\" alt=\"jumlah-bulan-antara-tanggal\" width=\"668\" height=\"415\"><\/figure><\/div><div class=\"gb-container gb-container-9e2850fe gb-container-mt\"> <a class=\"gb-button gb-button-71636faa gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/permintaan-kekuatan\/\">Power Query di Excel (Tutorial)<\/a><h2 class=\"gb-headline gb-headline-c566b2ed gb-headline-text gb-headline-mt-heading\"> Tutorial terkait <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-b15ed1bf gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-6e9de105\"><div class=\"gb-container gb-container-6e9de105\"><ul><li> Gabungkan [Gabungkan] Beberapa FILE Excel menjadi SATU BUKU CATATAN<\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/pencarianv-2\/\">Lakukan VLOOKUP di Power Query di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/data-yang-tidak-diputar\/\">Hapus pivot data di Excel menggunakan Power Query<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/rantai\/\">Power Query: menggabungkan nilai (teks dan angka)<\/a><\/li><\/ul><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-2109","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Bagaimana cara mendapatkan perbedaan tanggal di Power Query?<\/title>\n<meta name=\"description\" content=\"Dengan Power Query, Anda bisa mendapatkan perbedaan antara dua tanggal di Excel. Dan dalam tutorial ini, kita akan mempelajarinya secara detail.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/id\/perbedaan-tanggal\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara mendapatkan perbedaan tanggal di Power Query?\" \/>\n<meta property=\"og:description\" content=\"Dengan Power Query, Anda bisa mendapatkan perbedaan antara dua tanggal di Excel. Dan dalam tutorial ini, kita akan mempelajarinya secara detail.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/perbedaan-tanggal\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:16:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-difference-entre-deux-dates-dans-la-requete-de-puissance.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/perbedaan-tanggal\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/perbedaan-tanggal\/\",\"name\":\"Bagaimana cara mendapatkan perbedaan tanggal di Power Query?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/perbedaan-tanggal\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/perbedaan-tanggal\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-difference-entre-deux-dates-dans-la-requete-de-puissance.png\",\"datePublished\":\"2023-10-15T16:51:36+00:00\",\"dateModified\":\"2023-12-06T06:16:17+00:00\",\"description\":\"Dengan Power Query, Anda bisa mendapatkan perbedaan antara dua tanggal di Excel. Dan dalam tutorial ini, kita akan mempelajarinya secara detail.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/perbedaan-tanggal\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/perbedaan-tanggal\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/perbedaan-tanggal\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-difference-entre-deux-dates-dans-la-requete-de-puissance.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-difference-entre-deux-dates-dans-la-requete-de-puissance.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/perbedaan-tanggal\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara mendapatkan perbedaan tanggal di power query?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Bagaimana cara mendapatkan perbedaan tanggal di Power Query?","description":"Dengan Power Query, Anda bisa mendapatkan perbedaan antara dua tanggal di Excel. Dan dalam tutorial ini, kita akan mempelajarinya secara detail.","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:\/\/exceladvisor.org\/id\/perbedaan-tanggal\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara mendapatkan perbedaan tanggal di Power Query?","og_description":"Dengan Power Query, Anda bisa mendapatkan perbedaan antara dua tanggal di Excel. Dan dalam tutorial ini, kita akan mempelajarinya secara detail.","og_url":"https:\/\/exceladvisor.org\/id\/perbedaan-tanggal\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:16:17+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-difference-entre-deux-dates-dans-la-requete-de-puissance.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/perbedaan-tanggal\/","url":"https:\/\/exceladvisor.org\/id\/perbedaan-tanggal\/","name":"Bagaimana cara mendapatkan perbedaan tanggal di Power Query?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/perbedaan-tanggal\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/perbedaan-tanggal\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-difference-entre-deux-dates-dans-la-requete-de-puissance.png","datePublished":"2023-10-15T16:51:36+00:00","dateModified":"2023-12-06T06:16:17+00:00","description":"Dengan Power Query, Anda bisa mendapatkan perbedaan antara dua tanggal di Excel. Dan dalam tutorial ini, kita akan mempelajarinya secara detail.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/perbedaan-tanggal\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/perbedaan-tanggal\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/perbedaan-tanggal\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-difference-entre-deux-dates-dans-la-requete-de-puissance.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-difference-entre-deux-dates-dans-la-requete-de-puissance.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/perbedaan-tanggal\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara mendapatkan perbedaan tanggal di power query?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2109","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=2109"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2109\/revisions"}],"predecessor-version":[{"id":2514,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2109\/revisions\/2514"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2109"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}