{"id":15351,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/kupdegeri\/"},"modified":"2021-02-25T16:24:57","modified_gmt":"2021-02-25T16:24:57","slug":"cubevalue","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/cubevalue\/","title":{"rendered":"K\u00dcPDE\u011eER\u0130"},"content":{"rendered":"

Genel Bak\u0131\u015f: K\u00dcPDE\u011eER\u0130 Fonksiyonu<\/h2>\n

Microsoft Excel ve Google Sheets i\u00e7erisinde kullan\u0131lan K\u00dcPDE\u011eER\u0130 fonksiyonu, k\u00fcp veritabanlar\u0131ndaki \u00f6zetlenmi\u015f veri de\u011ferlerini elde etmek amac\u0131yla tasarlanm\u0131\u015ft\u0131r. Bu fonksiyon, i\u015f zekas\u0131 analizleri amac\u0131yla kullan\u0131lan \u00e7ok boyutlu veri k\u00fcmeleri (OLAP k\u00fcmeleri gibi) i\u00e7indeki veriler \u00fczerinde \u00e7al\u0131\u015f\u0131rken olduk\u00e7a yararl\u0131d\u0131r.<\/p>\n

Fonksiyon S\u00f6zdizimi ve Kullan\u0131m\u0131<\/h2>\n

K\u00dcPDE\u011eER\u0130 fonksiyonunun temel s\u00f6zdizimi a\u015fa\u011f\u0131da verilmi\u015ftir:<\/p>\n

K\u00dcPDE\u011eER\u0130(ba\u011flant\u0131, eleman1, [eleman2], ...)<\/code><\/pre>\n
    \n
  • ba\u011flant\u0131<\/code>: K\u00fcp hizmetine yap\u0131lan ba\u011flant\u0131y\u0131 tan\u0131mlayan bir dizedir.<\/li>\n
  • eleman<\/code>: K\u00fcp i\u00e7erisinde sorgulanacak olan \u00f6gelerden herhangi birinin ad\u0131d\u0131r. Bu \u00f6ge, k\u00fcp\u00fcn eksenlerinden birindeki bir veya daha fazla \u00fcye ya da bir k\u00fcp \u00f6zelli\u011fi olabilir.<\/li>\n<\/ul>\n
    \u00d6rnek kullan\u0131m a\u015fa\u011f\u0131daki gibidir:<\/p>\n
    =K\u00dcPDE\u011eER\u0130(\"Sat\u0131\u015fK\u00fcp\u00fc\", \"[Zaman].[2019].[Q1]\", \"[\u00dcr\u00fcn].[T\u00fcm \u00dcr\u00fcnler]\")<\/code><\/pre>\n
    Pratik Kullan\u0131m Senaryolar\u0131<\/h2>\n
    Senaryo 1: Sat\u0131\u015f Verileri Analizi<\/h2>\n
    Bir i\u015fletmenin 2019 y\u0131l\u0131n\u0131n ilk \u00e7eyre\u011fine ait sat\u0131\u015f verilerini, \u00fcr\u00fcn kategorisine g\u00f6re analiz etmek istedi\u011fini d\u00fc\u015f\u00fcnelim. Veriler \u015fu \u015fekilde bir k\u00fcpte saklanm\u0131\u015f olsun:<\/p>\n
    =K\u00dcPDE\u011eER\u0130(\"Sat\u0131\u015fK\u00fcp\u00fc\", \"[Zaman].[2019].[Q1]\", \"[Kategori].[Elektronik]\")<\/code><\/pre>\n
    Bu form\u00fcl, 2019 y\u0131l\u0131n\u0131n ilk \u00e7eyre\u011finde ‘Elektronik’ kategorisindeki \u00fcr\u00fcnlerin toplam sat\u0131\u015flar\u0131n\u0131 verir.<\/p>\n
    Senaryo 2: \u00c7oklu Kriterlerle Analiz<\/h2>\n
    Bir i\u015fletmenin 2019 ve 2020 y\u0131llar\u0131 boyunca, ‘Elektronik’ ve ‘Giyim’ kategorilerindeki sat\u0131\u015flar\u0131 kar\u015f\u0131la\u015ft\u0131rmak istedi\u011fini farz edelim.<\/p>\n
    =K\u00dcPDE\u011eER\u0130(\"Sat\u0131\u015fK\u00fcp\u00fc\", \"[Zaman].[2019]\", \"[Kategori].[Elektronik]\", \"[Zaman].[2020]\", \"[Kategori].[Giyim]\")<\/code><\/pre>\n
    Bu form\u00fcl, 2019 ve 2020 y\u0131llar\u0131 aras\u0131nda ‘Elektronik’ ve ‘Giyim’ kategorileri alt\u0131ndaki sat\u0131\u015flar\u0131 kar\u015f\u0131la\u015ft\u0131rmak i\u00e7in kullan\u0131labilir. Belirtilen her bir eleman, k\u00fcpteki farkl\u0131 bir boyutu temsil eder ve form\u00fcl, bu boyutlar aras\u0131 ili\u015fkiyi analiz eder.<\/p>\n
    K\u00fcp Verileri ile \u00c7al\u0131\u015f\u0131rken \u0130pu\u00e7lar\u0131<\/h2>\n
    K\u00dcPDE\u011eER\u0130 fonksiyonu ile \u00e7al\u0131\u015f\u0131rken a\u015fa\u011f\u0131daki ipu\u00e7lar\u0131n\u0131 g\u00f6z \u00f6n\u00fcnde bulundurun:<\/p>\n
      \n
    • K\u00fcp fonksiyonlar\u0131, veri analizi i\u00e7in g\u00fc\u00e7l\u00fc ara\u00e7lar sunar; ancak, do\u011fru veri ba\u011flam\u0131n\u0131 ve yap\u0131y\u0131 anlamak \u00f6nemlidir.<\/li>\n
    • K\u00fcp i\u00e7indeki verilere eri\u015fim i\u00e7in gerekli izinlerin ve ba\u011flant\u0131n\u0131n do\u011fru yap\u0131land\u0131r\u0131ld\u0131\u011f\u0131ndan emin olun.<\/li>\n
    • B\u00fcy\u00fck veri setleri \u00fczerinde \u00e7al\u0131\u015f\u0131rken, performans\u0131 optimize etmek amac\u0131yla sorgular\u0131n\u0131z\u0131 olabildi\u011fince spesifik hale getirin.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
      Bir k\u00fcpten toplam de\u011feri verir<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[587],"tags":[],"class_list":["post-15351","post","type-post","status-publish","format-standard","hentry","category-kup"],"acf":[],"yoast_head":"\nExcel'de CUBEVALUE (K\u00dcPDE\u011eER\u0130) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da CUBEVALUE (K\u00dcPDE\u011eER\u0130) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/tr\/cubevalue\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de CUBEVALUE (K\u00dcPDE\u011eER\u0130) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da CUBEVALUE (K\u00dcPDE\u011eER\u0130) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/tr\/cubevalue\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T16:24:57+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel'de CUBEVALUE (K\u00dcPDE\u011eER\u0130) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/cubevalue\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/cubevalue\/\",\"name\":\"Excel'de CUBEVALUE (K\u00dcPDE\u011eER\u0130) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:52+00:00\",\"dateModified\":\"2021-02-25T16:24:57+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da CUBEVALUE (K\u00dcPDE\u011eER\u0130) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/tr\/cubevalue\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/cubevalue\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/cubevalue\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"K\u00fcp\",\"item\":\"https:\/\/functiontranslator.com\/tr\/kup\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"K\u00dcPDE\u011eER\u0130\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/tr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel'de CUBEVALUE (K\u00dcPDE\u011eER\u0130) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da CUBEVALUE (K\u00dcPDE\u011eER\u0130) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","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:\/\/functiontranslator.com\/tr\/cubevalue\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de CUBEVALUE (K\u00dcPDE\u011eER\u0130) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da CUBEVALUE (K\u00dcPDE\u011eER\u0130) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","og_url":"https:\/\/functiontranslator.com\/tr\/cubevalue\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:24:57+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de CUBEVALUE (K\u00dcPDE\u011eER\u0130) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","twitter_misc":{"Yazan:":"glavadmin","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/tr\/cubevalue\/","url":"https:\/\/functiontranslator.com\/tr\/cubevalue\/","name":"Excel'de CUBEVALUE (K\u00dcPDE\u011eER\u0130) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:52+00:00","dateModified":"2021-02-25T16:24:57+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da CUBEVALUE (K\u00dcPDE\u011eER\u0130) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/tr\/cubevalue\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/cubevalue\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/cubevalue\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"K\u00fcp","item":"https:\/\/functiontranslator.com\/tr\/kup\/"},{"@type":"ListItem","position":3,"name":"K\u00dcPDE\u011eER\u0130"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/tr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15351","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/comments?post=15351"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15351\/revisions"}],"predecessor-version":[{"id":27050,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15351\/revisions\/27050"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15351"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15351"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15351"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}