{"id":2724,"date":"2023-06-09T17:25:13","date_gmt":"2023-06-09T22:25:13","guid":{"rendered":"http:\/\/ninmonkeys.com\/blog\/?p=2724"},"modified":"2023-06-09T18:01:07","modified_gmt":"2023-06-09T23:01:07","slug":"whats-new-may-2023","status":"publish","type":"post","link":"https:\/\/ninmonkeys.com\/blog\/2023\/06\/09\/whats-new-may-2023\/","title":{"rendered":"What&#8217;s New: May 2023: Dax Functions, and PBI Fabric"},"content":{"rendered":"\n<p>Dax Keeps pouring out new Functions. <\/p>\n\n\n\n\n\n<h3>DAX <\/h3>\n\n\n\n<p><a href=\"https:\/\/learn.microsoft.com\/en-us\/dax\/new-dax-functions\">So Many New <code class=\"\" data-line=\"\">DAX<\/code> functions<\/a><\/p>\n\n\n\n<ul><li><a href=\"https:\/\/learn.microsoft.com\/en-us\/dax\/new-dax-functions\">New: <code class=\"\" data-line=\"\">MatchBy<\/code>, <code class=\"\" data-line=\"\">Rank<\/code>, <code class=\"\" data-line=\"\">RowNumber<\/code>, <code class=\"\" data-line=\"\">LINEST<\/code>, <code class=\"\" data-line=\"\">LINESTX<\/code> , <code class=\"\" data-line=\"\">Index<\/code>, <code class=\"\" data-line=\"\">Offset<\/code>, <code class=\"\" data-line=\"\">OrderBy<\/code>, <code class=\"\" data-line=\"\">PartitionBy<\/code>, <code class=\"\" data-line=\"\">Window<\/code>, <code class=\"\" data-line=\"\">EvaluateAndLog<\/code>, <code class=\"\" data-line=\"\">ToCsv<\/code>, <code class=\"\" data-line=\"\">ToJson<\/code>, <code class=\"\" data-line=\"\">NetWorkDays<\/code><\/a> [ from 2022-07 to 2023-06 ]<\/li><li><a href=\"https:\/\/powerbi.microsoft.com\/en-us\/blog\/power-bi-april-2023-feature-summary\/#post-23001-_Toc826225249\">new <code class=\"\" data-line=\"\">RANK<\/code> and <code class=\"\" data-line=\"\">ROWNUMBER<\/code><\/a> [2023-04] <\/li><li><a href=\"https:\/\/powerbi.microsoft.com\/en-us\/blog\/power-bi-april-2023-feature-summary\/#post-23001-_Toc439693147\"><code class=\"\" data-line=\"\">ORDERBY<\/code> was updated<\/a> [2023-04]<\/li><li><a href=\"https:\/\/powerbi.microsoft.com\/en-us\/blog\/power-bi-december-2022-feature-summary\/#post-21693-_Toc121395730\">new: <code class=\"\" data-line=\"\">INDEX<\/code>, <code class=\"\" data-line=\"\">OFFSET<\/code>, <code class=\"\" data-line=\"\">WINDOW<\/code><\/a> [2022-12]<ul><li>there&#8217;s a long introduction that covers how and some of why you would use these new functions (no link because that blog had no header permalinks)<\/li><\/ul><\/li><li><a href=\"https:\/\/community.fabric.microsoft.com\/t5\/Community-Blog\/New-Functions-in-DAX-in-2022\/ba-p\/3047638\">community post using many of the new dax functions<\/a> ( <a href=\"https:\/\/community.fabric.microsoft.com\/t5\/user\/viewprofilepage\/user-id\/22640\">Kumail<\/a> )<\/li><li><a href=\"https:\/\/powerbi.microsoft.com\/en-us\/blog\/power-bi-november-2022-feature-summary\/#post-21321-_Toc117515805\">new: <code class=\"\" data-line=\"\">EvaluateAndLog<\/code>, <code class=\"\" data-line=\"\">ToCsv<\/code>, and <code class=\"\" data-line=\"\">ToJson<\/code><\/a> [2022-11], <a href=\"https:\/\/learn.microsoft.com\/en-us\/dax\/evaluateandlog-function-dax\">docs: EvaluateAndLog<\/a><\/li><li><a href=\"https:\/\/github.com\/pbidax\/DAXDebugOutput\/releases\/\"><code class=\"\" data-line=\"\">DAXDebugOutput<\/code> <code class=\"\" data-line=\"\">v0.1<\/code><\/a> [ <a href=\"https:\/\/powerbi.microsoft.com\/en-us\/blog\/power-bi-november-2022-feature-summary\/#post-21321-_Toc117515805\">from Nov2022<\/a> ] using sql profiler <\/li><\/ul>\n\n\n\n<h2>CoPilot, and Fabric<\/h2>\n\n\n\n<ul><li><a href=\"https:\/\/powerbi.microsoft.com\/en-us\/blog\/introducing-microsoft-fabric-and-copilot-in-microsoft-power-bi\/\">CoPilot<\/a><\/li><li><a href=\"https:\/\/powerbi.microsoft.com\/en-us\/blog\/microsoft-digital-event-may-24-25\/\">Lots of Fabric <\/a> ( plus half a dozen top level fabric announcements  posts, like  <a href=\"https:\/\/blog.fabric.microsoft.com\/en-us\/blog\/introducing-data-factory-in-microsoft-fabric\/\">Data Factory Fabric<\/a> <\/li><li>You can now <a href=\"https:\/\/powerbi.microsoft.com\/en-us\/blog\/power-bi-april-2023-feature-summary\/#post-23001-_Toc1669406361\">Declare your <strong>measure with an optional <code class=\"\" data-line=\"\">Format()<\/code>ing  measure<\/strong>, without using external tools.<\/a> <\/li><\/ul>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"Microsoft Fabric Launch Digital Event (Day 1)\" width=\"580\" height=\"326\" src=\"https:\/\/www.youtube.com\/embed\/1o_QDFq6gzE?start=2688&#038;feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<h2>Power BI Feature Summaries<\/h2>\n\n\n\n<ul><li><a href=\"https:\/\/powerbi.microsoft.com\/en-us\/blog\/power-bi-may-2023-feature-summary\/\" data-type=\"URL\" data-id=\"https:\/\/powerbi.microsoft.com\/en-us\/blog\/power-bi-may-2023-feature-summary\/\">https:\/\/powerbi.microsoft.com\/en-us\/blog\/power-bi-may-2023-feature-summary\/<\/a><ul><li>new: <a href=\"https:\/\/powerbi.microsoft.com\/en-us\/blog\/power-bi-may-2023-feature-summary\/#post-23312-_Toc134425719\">MatchBy<\/a><\/li><\/ul><\/li><li><a href=\"https:\/\/powerbi.microsoft.com\/en-us\/blog\/power-bi-april-2023-feature-summary\/\">https:\/\/powerbi.microsoft.com\/en-us\/blog\/power-bi-april-2023-feature-summary\/<\/a><\/li><li><a href=\"https:\/\/powerbi.microsoft.com\/en-us\/blog\/power-bi-march-2023-feature-summary\/\">https:\/\/powerbi.microsoft.com\/en-us\/blog\/power-bi-march-2023-feature-summary\/<\/a><\/li><li><a href=\"https:\/\/powerbi.microsoft.com\/en-us\/blog\/power-bi-february-2023-feature-summary\/\u2028\">https:\/\/powerbi.microsoft.com\/en-us\/blog\/power-bi-february-2023-feature-summary\/<\/a><\/li><li><a href=\"https:\/\/powerbi.microsoft.com\/en-us\/blog\/power-bi-december-2022-feature-summary\/#post-21693-_Toc121395730\">Power BI December 2022 Feature Summary<\/a><\/li><li><a href=\"https:\/\/powerbi.microsoft.com\/en-us\/blog\/power-bi-november-2022-feature-summary\/#post-21693-_Toc121395730\">Power BI November 2022 Feature Summary<\/a><ul><li><em>[preview] <\/em><a href=\"https:\/\/powerbi.microsoft.com\/en-us\/blog\/power-bi-november-2022-feature-summary\/#post-21321-_Toc117515801\">Create dynamic slicers using <strong>field parameters<\/strong><\/a> and <a href=\"https:\/\/learn.microsoft.com\/en-us\/power-bi\/create-reports\/power-bi-field-parameters\">beta info<\/a><\/li><\/ul><\/li><li><a href=\"https:\/\/powerbi.microsoft.com\/en-us\/blog\/power-bi-november-2022-feature-summary\/#post-21693-_Toc121395730\">Power BI October 2022 Feature Summary<\/a><\/li><li><a href=\"https:\/\/powerbi.microsoft.com\/en-us\/blog\/power-bi-november-2022-feature-summary\/#post-21693-_Toc121395730\">Power BI September 2022 Feature Summary<\/a><\/li><li><a href=\"https:\/\/powerbi.microsoft.com\/en-us\/blog\/power-bi-august-2022-feature-summary\/\">Power BI August 2022 Feature Summary<\/a><\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Dax Keeps pouring out new Functions. DAX So Many New DAX functions New: MatchBy, Rank, RowNumber, LINEST, LINESTX , Index, Offset, OrderBy, PartitionBy, Window, EvaluateAndLog, ToCsv, ToJson, NetWorkDays [ from 2022-07 to 2023-06 ] new RANK and ROWNUMBER [2023-04] ORDERBY was updated [2023-04] new: INDEX, OFFSET, WINDOW [2022-12] there&#8217;s a long introduction that covers how [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[25],"tags":[87,149,6,26],"_links":{"self":[{"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/posts\/2724"}],"collection":[{"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/comments?post=2724"}],"version-history":[{"count":23,"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/posts\/2724\/revisions"}],"predecessor-version":[{"id":2754,"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/posts\/2724\/revisions\/2754"}],"wp:attachment":[{"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/media?parent=2724"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/categories?post=2724"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/tags?post=2724"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}