{"id":171,"date":"2023-05-18T12:09:23","date_gmt":"2023-05-18T12:09:23","guid":{"rendered":"https:\/\/datadandies.nl\/?p=171"},"modified":"2023-05-18T12:09:23","modified_gmt":"2023-05-18T12:09:23","slug":"compound-interest-samengestelde-rente-in-power-query-met-een-loop","status":"publish","type":"post","link":"https:\/\/datadandies.nl\/index.php\/2023\/05\/18\/compound-interest-samengestelde-rente-in-power-query-met-een-loop\/","title":{"rendered":"Compound interest \/ samengestelde rente in Power Query met een loop"},"content":{"rendered":"\n<p>In een van mijn vorige posts hebben we gezien hoe je compound interest \/ samengestelde rente in SQL kunt berekenen. Maar hoe doe je dit in Power Query?&nbsp;<\/p>\n\n\n\n<p>Dit kan met behulp van de functie List.Generate. Eigenlijk maak je met behulp van de onderstaande functie een loop. Je geeft de functie een startpunt, een eindpunt en instructies over hoe hij de lijst record voor record op moet bouwen (in dit geval steeds het voorgaande record * 1.05).&nbsp;&nbsp;<\/p>\n\n\n\n<p>= List.Generate(&nbsp;<\/p>\n\n\n\n<p>&nbsp;&nbsp;&nbsp; ()=&gt;[i=0, value=100],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<\/p>\n\n\n\n<p>&nbsp;&nbsp;&nbsp; each [i]&lt;10,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<\/p>\n\n\n\n<p>&nbsp;&nbsp;&nbsp; each [i=[i]+1, value=[value]*1.05],&nbsp;&nbsp;<\/p>\n\n\n\n<p>&nbsp;&nbsp;&nbsp; each [value]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<\/p>\n\n\n\n<p>&nbsp; )<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"361\" src=\"https:\/\/datadandies.nl\/wp-content\/uploads\/2023\/05\/20230403-Loop-met-compound-interest-samengestelde-rente-in-Power-Query-1024x361.png\" alt=\"\" class=\"wp-image-172\" srcset=\"https:\/\/datadandies.nl\/wp-content\/uploads\/2023\/05\/20230403-Loop-met-compound-interest-samengestelde-rente-in-Power-Query-1024x361.png 1024w, https:\/\/datadandies.nl\/wp-content\/uploads\/2023\/05\/20230403-Loop-met-compound-interest-samengestelde-rente-in-Power-Query-300x106.png 300w, https:\/\/datadandies.nl\/wp-content\/uploads\/2023\/05\/20230403-Loop-met-compound-interest-samengestelde-rente-in-Power-Query-768x271.png 768w, https:\/\/datadandies.nl\/wp-content\/uploads\/2023\/05\/20230403-Loop-met-compound-interest-samengestelde-rente-in-Power-Query-1536x542.png 1536w, https:\/\/datadandies.nl\/wp-content\/uploads\/2023\/05\/20230403-Loop-met-compound-interest-samengestelde-rente-in-Power-Query.png 1760w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>In een van mijn vorige posts hebben we gezien hoe je compound interest \/ samengestelde rente in SQL kunt berekenen. Maar hoe doe je dit in Power Query?&nbsp; Dit kan met behulp van de functie List.Generate. Eigenlijk maak je met behulp van de onderstaande functie een loop. Je geeft de functie een startpunt, een eindpunt&hellip;<\/p>\n<p class=\"more-link\"><a href=\"https:\/\/datadandies.nl\/index.php\/2023\/05\/18\/compound-interest-samengestelde-rente-in-power-query-met-een-loop\/\" class=\"themebutton\">Read More<\/a><\/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":[11,4],"class_list":["post-171","post","type-post","status-publish","format-standard","hentry","category-blog","tag-powerquery","tag-sql"],"_links":{"self":[{"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/posts\/171","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/comments?post=171"}],"version-history":[{"count":1,"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/posts\/171\/revisions"}],"predecessor-version":[{"id":173,"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/posts\/171\/revisions\/173"}],"wp:attachment":[{"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/media?parent=171"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/categories?post=171"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/tags?post=171"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}