{"id":781,"date":"2025-09-26T10:18:22","date_gmt":"2025-09-26T10:18:22","guid":{"rendered":"https:\/\/datadandies.nl\/?p=781"},"modified":"2025-09-26T10:18:22","modified_gmt":"2025-09-26T10:18:22","slug":"user-defined-functions-in-power-bi","status":"publish","type":"post","link":"https:\/\/datadandies.nl\/index.php\/2025\/09\/26\/user-defined-functions-in-power-bi\/","title":{"rendered":"User Defined Functions in Power BI"},"content":{"rendered":"\n<p>Do you want to implement certain business logic in multiple measures or calculated columns in your semantic model and maintain that logic in one place?<br><br>With User Defined Functions in Power BI you can do just that. Your own custom functions, reusable across the entire Power BI Semantic Model in measures and calculated columns.<br><br>It&#8217;s here since the september update.<br><br>Some additional reading material regarding user defined functions:<br><br><a href=\"https:\/\/powerbi.microsoft.com\/en-us\/blog\/power-bi-september-2025-feature-summary\/#post-30998-_Toc208591574\">https:\/\/powerbi.microsoft.com\/en-us\/blog\/power-bi-september-2025-feature-summary\/#post-30998-_Toc208591574<\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/www.sqlbi.com\/articles\/introducing-user-defined-functions-in-dax\">https:\/\/www.sqlbi.com\/articles\/introducing-user-defined-functions-in-dax<\/a><\/p>\n\n\n<div class=\"ead-preview\"><div class=\"ead-document\" style=\"position: relative;padding-top: 90%;\"><div class=\"ead-iframe-wrapper\"><iframe src=\"\/\/docs.google.com\/viewer?url=https%3A%2F%2Fdatadandies.nl%2Fwp-content%2Fuploads%2F2025%2F09%2F20250930-Power-BI-custom-functions.pdf&amp;embedded=true&amp;hl=en\" title=\"Ingesloten document\" class=\"ead-iframe\" style=\"width: 100%;height: 100%;border: none;position: absolute;left: 0;top: 0;visibility: hidden;\"><\/iframe><\/div>\t\t\t<div class=\"ead-document-loading\" style=\"width:100%;height:100%;position:absolute;left:0;top:0;z-index:10;\">\n\t\t\t\t<div class=\"ead-loading-wrap\">\n\t\t\t\t\t<div class=\"ead-loading-main\">\n\t\t\t\t\t\t<div class=\"ead-loading\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/datadandies.nl\/wp-content\/plugins\/embed-any-document\/images\/loading.svg\" width=\"55\" height=\"55\" alt=\"Lader\">\n\t\t\t\t\t\t\t<span>Bezig met laden&#8230;<\/span>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t<div class=\"ead-loading-foot\">\n\t\t\t\t\t\t<div class=\"ead-loading-foot-title\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/datadandies.nl\/wp-content\/plugins\/embed-any-document\/images\/EAD-logo.svg\" alt=\"EAD logo\" width=\"36\" height=\"23\"\/>\n\t\t\t\t\t\t\t<span>Duurt het te lang?<\/span>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<p>\n\t\t\t\t\t\t\t<div class=\"ead-document-btn ead-reload-btn\" role=\"button\">\n\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/datadandies.nl\/wp-content\/plugins\/embed-any-document\/images\/reload.svg\" alt=\"Opnieuw laden\" width=\"12\" height=\"12\"\/> Laad het document opnieuw\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<span>|<\/span>\n\t\t\t\t\t\t\t<a href=\"https:\/\/datadandies.nl\/wp-content\/uploads\/2025\/09\/20250930-Power-BI-custom-functions.pdf\" class=\"ead-document-btn\" target=\"_blank\">\n\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/datadandies.nl\/wp-content\/plugins\/embed-any-document\/images\/open.svg\" alt=\"Open\" width=\"12\" height=\"12\"\/> Openen in nieuwe tab\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Do you want to implement certain business logic in multiple measures or calculated columns in your semantic model and maintain that logic in one place? With User Defined Functions in Power BI you can do just that. Your own custom functions, reusable across the entire Power BI Semantic Model in measures and calculated columns. It&#8217;s&hellip;<\/p>\n<p class=\"more-link\"><a href=\"https:\/\/datadandies.nl\/index.php\/2025\/09\/26\/user-defined-functions-in-power-bi\/\" class=\"themebutton\">Read More<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[3],"class_list":["post-781","post","type-post","status-publish","format-standard","hentry","category-blog","tag-powerbi"],"_links":{"self":[{"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/posts\/781","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=781"}],"version-history":[{"count":1,"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/posts\/781\/revisions"}],"predecessor-version":[{"id":783,"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/posts\/781\/revisions\/783"}],"wp:attachment":[{"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/media?parent=781"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/categories?post=781"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/tags?post=781"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}