{"id":898,"date":"2020-02-18T10:01:35","date_gmt":"2020-02-18T08:01:35","guid":{"rendered":"http:\/\/bi-vaerkstedet.dk\/?p=898"},"modified":"2020-02-18T10:03:13","modified_gmt":"2020-02-18T08:03:13","slug":"related-vs-lookupvalue","status":"publish","type":"post","link":"http:\/\/bi-vaerkstedet.dk\/?p=898","title":{"rendered":"RELATED vs. LOOKUPVALUE"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Den m\u00e5de de to DAX funktioner RELATED og LOOKUPVALUE fungerer p\u00e5 kan synes ensarter og nogen gange kan de erstatte hinanden, men der er ogs\u00e5 v\u00e6sentlige forskelle &#8211; s\u00e5 hvorn\u00e5r bruges RELATED og hvorn\u00e5r LOOKUPVALUE?<\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h4 class=\"wp-block-heading\">Hvorfor bruge RELATED?<\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>RELATED kr\u00e6ver at tabellerne er relaterede.<\/li><li>RELATED er simpel at bruge &#8211; den kr\u00e6ver kun \u00e9n parameter.<\/li><li>RELATED kan virke gennem flere tabeller, s\u00e5 l\u00e6nge de er forbundet med \u00e9n til mage relationer.<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Hvorfor bruge LOOKUPVALUE?<\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>LOOKUPVALUE kr\u00e6ver ikke at tabellerne er relaterede.<\/li><li>LOOKUPVALUE kan bruge flere samtidige n\u00f8gler. Man kan for eksempel bruge b\u00e5de for- og efternavn sammen.<\/li><li>LOOKUPVALUE kr\u00e6ver ikke en anden tabel. LOOKUPVALUE kan hente v\u00e6rdier fra den tabel formelen knytter an til, typisk hentes v\u00e6rdier fra andre kolonner ved brug af en n\u00f8gle.<\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Den m\u00e5de de to DAX funktioner RELATED og LOOKUPVALUE fungerer p\u00e5 kan synes ensarter og nogen gange kan de erstatte hinanden, men der er ogs\u00e5 v\u00e6sentlige forskelle &#8211; s\u00e5 hvorn\u00e5r bruges RELATED og hvorn\u00e5r LOOKUPVALUE? Hvorfor bruge RELATED? RELATED kr\u00e6ver at tabellerne er relaterede. RELATED er simpel at bruge &#8211; den kr\u00e6ver kun \u00e9n parameter. RELATED kan virke gennem flere tabeller, s\u00e5 l\u00e6nge de er forbundet med \u00e9n til mage&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-898","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"gutentor_comment":0,"_links":{"self":[{"href":"http:\/\/bi-vaerkstedet.dk\/index.php?rest_route=\/wp\/v2\/posts\/898","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bi-vaerkstedet.dk\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bi-vaerkstedet.dk\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bi-vaerkstedet.dk\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/bi-vaerkstedet.dk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=898"}],"version-history":[{"count":3,"href":"http:\/\/bi-vaerkstedet.dk\/index.php?rest_route=\/wp\/v2\/posts\/898\/revisions"}],"predecessor-version":[{"id":901,"href":"http:\/\/bi-vaerkstedet.dk\/index.php?rest_route=\/wp\/v2\/posts\/898\/revisions\/901"}],"wp:attachment":[{"href":"http:\/\/bi-vaerkstedet.dk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=898"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bi-vaerkstedet.dk\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=898"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bi-vaerkstedet.dk\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=898"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}