<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Data Intelligence Hub on Medium]]></title>
        <description><![CDATA[Stories by Data Intelligence Hub on Medium]]></description>
        <link>https://medium.com/@shrikanth-hebbar?source=rss-abc22cecd66f------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*MrMgZnyWFMuKBALmLBUJOA.jpeg</url>
            <title>Stories by Data Intelligence Hub on Medium</title>
            <link>https://medium.com/@shrikanth-hebbar?source=rss-abc22cecd66f------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Tue, 17 Nov 2026 16:54:32 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@shrikanth-hebbar/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Power BI : Essential external tools for development]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://medium.com/microsoft-power-bi/power-bi-essential-external-tools-for-development-7abf4105a54f?source=rss-abc22cecd66f------2"><img src="https://cdn-images-1.medium.com/max/600/1*x-5oP5L0yrJJZP1SU-QA2w.gif" width="600"></a></p><p class="medium-feed-snippet">Color Picker | Microsoft Power Toys</p><p class="medium-feed-link"><a href="https://medium.com/microsoft-power-bi/power-bi-essential-external-tools-for-development-7abf4105a54f?source=rss-abc22cecd66f------2">Continue reading on Power BI »</a></p></div>]]></description>
            <link>https://medium.com/microsoft-power-bi/power-bi-essential-external-tools-for-development-7abf4105a54f?source=rss-abc22cecd66f------2</link>
            <guid isPermaLink="false">https://medium.com/p/7abf4105a54f</guid>
            <category><![CDATA[design]]></category>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[data-analytics]]></category>
            <category><![CDATA[power-bi]]></category>
            <category><![CDATA[ui]]></category>
            <dc:creator><![CDATA[Data Intelligence Hub]]></dc:creator>
            <pubDate>Thu, 20 Feb 2025 19:07:52 GMT</pubDate>
            <atom:updated>2025-02-22T08:13:11.729Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[Learning Data Governance -Day 1]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://medium.com/data-intelligence-hub/learning-data-governance-day-1-e3eec4db7b4c?source=rss-abc22cecd66f------2"><img src="https://cdn-images-1.medium.com/max/2123/1*x30l7XXnAaCp-ENo-PJ1wQ.png" width="2123"></a></p><p class="medium-feed-snippet">What is Data Governance and Why is it Important?</p><p class="medium-feed-link"><a href="https://medium.com/data-intelligence-hub/learning-data-governance-day-1-e3eec4db7b4c?source=rss-abc22cecd66f------2">Continue reading on Data Intelligence Hub »</a></p></div>]]></description>
            <link>https://medium.com/data-intelligence-hub/learning-data-governance-day-1-e3eec4db7b4c?source=rss-abc22cecd66f------2</link>
            <guid isPermaLink="false">https://medium.com/p/e3eec4db7b4c</guid>
            <category><![CDATA[data-governance]]></category>
            <category><![CDATA[data-governance-tools]]></category>
            <category><![CDATA[data-governance-framework]]></category>
            <dc:creator><![CDATA[Data Intelligence Hub]]></dc:creator>
            <pubDate>Fri, 27 Dec 2024 15:01:44 GMT</pubDate>
            <atom:updated>2024-12-27T15:02:24.747Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[Applications of Data Analytics across Various Domains]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://medium.com/data-intelligence-hub/applications-of-data-analytics-across-various-domains-daa7a7acb819?source=rss-abc22cecd66f------2"><img src="https://cdn-images-1.medium.com/max/2600/0*CfPdEeFNPTyUPyNv" width="2947"></a></p><p class="medium-feed-snippet">&#x201C;&#x2728; Not a Medium member? Click here to read this blog for free!&#x201D;</p><p class="medium-feed-link"><a href="https://medium.com/data-intelligence-hub/applications-of-data-analytics-across-various-domains-daa7a7acb819?source=rss-abc22cecd66f------2">Continue reading on Data Intelligence Hub »</a></p></div>]]></description>
            <link>https://medium.com/data-intelligence-hub/applications-of-data-analytics-across-various-domains-daa7a7acb819?source=rss-abc22cecd66f------2</link>
            <guid isPermaLink="false">https://medium.com/p/daa7a7acb819</guid>
            <category><![CDATA[data-analytics-tools]]></category>
            <category><![CDATA[data-analytics]]></category>
            <category><![CDATA[data-analytics-courses]]></category>
            <dc:creator><![CDATA[Data Intelligence Hub]]></dc:creator>
            <pubDate>Thu, 26 Dec 2024 18:49:30 GMT</pubDate>
            <atom:updated>2024-12-26T18:50:51.602Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[Data & Cloud Certifications list]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://medium.com/data-intelligence-hub/data-cloud-certifications-list-bbf3e616036b?source=rss-abc22cecd66f------2"><img src="https://cdn-images-1.medium.com/max/2600/0*_5VqwSXDKKSNX9eW" width="3606"></a></p><p class="medium-feed-snippet">A Comprehensive Guide to Certifications offered by various providers</p><p class="medium-feed-link"><a href="https://medium.com/data-intelligence-hub/data-cloud-certifications-list-bbf3e616036b?source=rss-abc22cecd66f------2">Continue reading on Data Intelligence Hub »</a></p></div>]]></description>
            <link>https://medium.com/data-intelligence-hub/data-cloud-certifications-list-bbf3e616036b?source=rss-abc22cecd66f------2</link>
            <guid isPermaLink="false">https://medium.com/p/bbf3e616036b</guid>
            <category><![CDATA[cloud-computing]]></category>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[certification]]></category>
            <category><![CDATA[data-engineering]]></category>
            <category><![CDATA[data-analysis]]></category>
            <dc:creator><![CDATA[Data Intelligence Hub]]></dc:creator>
            <pubDate>Tue, 24 Dec 2024 18:20:53 GMT</pubDate>
            <atom:updated>2024-12-24T18:23:40.974Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[Python Frameworks for creating Web Applications]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://medium.com/data-intelligence-hub/python-frameworks-for-creating-web-applications-841c28405118?source=rss-abc22cecd66f------2"><img src="https://cdn-images-1.medium.com/max/2600/0*hRhIRgECr-azdcXF" width="5472"></a></p><p class="medium-feed-snippet">When building applications&#x200A;&#x2014;&#x200A;whether it&#x2019;s a dashboard, a machine learning demo, or a full-scale web app&#x200A;&#x2014;&#x200A;the choice of framework is&#x2026;</p><p class="medium-feed-link"><a href="https://medium.com/data-intelligence-hub/python-frameworks-for-creating-web-applications-841c28405118?source=rss-abc22cecd66f------2">Continue reading on Data Intelligence Hub »</a></p></div>]]></description>
            <link>https://medium.com/data-intelligence-hub/python-frameworks-for-creating-web-applications-841c28405118?source=rss-abc22cecd66f------2</link>
            <guid isPermaLink="false">https://medium.com/p/841c28405118</guid>
            <category><![CDATA[python-web-developer]]></category>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[python-programming]]></category>
            <category><![CDATA[python]]></category>
            <category><![CDATA[data-science]]></category>
            <dc:creator><![CDATA[Data Intelligence Hub]]></dc:creator>
            <pubDate>Sat, 30 Nov 2024 17:54:45 GMT</pubDate>
            <atom:updated>2024-11-30T17:55:52.525Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[Data Analysis Use Cases : Pareto Analysis]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://medium.com/microsoft-power-bi/data-analysis-use-cases-pareto-analysis-e54bfd0f079a?source=rss-abc22cecd66f------2"><img src="https://cdn-images-1.medium.com/max/1588/1*E1DKOySGHrLiryYloMoYCQ.jpeg" width="1588"></a></p><p class="medium-feed-snippet">Targeting high valued data using pareto-based strategy using Power BI</p><p class="medium-feed-link"><a href="https://medium.com/microsoft-power-bi/data-analysis-use-cases-pareto-analysis-e54bfd0f079a?source=rss-abc22cecd66f------2">Continue reading on Power BI »</a></p></div>]]></description>
            <link>https://medium.com/microsoft-power-bi/data-analysis-use-cases-pareto-analysis-e54bfd0f079a?source=rss-abc22cecd66f------2</link>
            <guid isPermaLink="false">https://medium.com/p/e54bfd0f079a</guid>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[programming]]></category>
            <category><![CDATA[data-analytics]]></category>
            <category><![CDATA[power-bi]]></category>
            <category><![CDATA[data-science]]></category>
            <dc:creator><![CDATA[Data Intelligence Hub]]></dc:creator>
            <pubDate>Sun, 17 Nov 2024 08:53:00 GMT</pubDate>
            <atom:updated>2024-11-18T07:44:02.347Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[DAX Mastery: Information Functions (Day 9)]]></title>
            <link>https://medium.com/microsoft-power-bi/dax-mastery-information-functions-day-9-b2653c9bd73a?source=rss-abc22cecd66f------2</link>
            <guid isPermaLink="false">https://medium.com/p/b2653c9bd73a</guid>
            <category><![CDATA[dax]]></category>
            <category><![CDATA[business-intelligence]]></category>
            <category><![CDATA[data-anlytics]]></category>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[power-bi]]></category>
            <dc:creator><![CDATA[Data Intelligence Hub]]></dc:creator>
            <pubDate>Sun, 15 Sep 2024 08:24:50 GMT</pubDate>
            <atom:updated>2024-09-17T20:24:55.461Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/886/1*xDQmmgz4cKcpvgzYLPpoig.png" /></figure><p>Imagine you’re the data analyst of operations in a large corporate library system, tasked with ensuring that all books, research papers, and digital content are meticulously organized and instantly accessible. Each department within your organization has unique needs, similar to how different library visitors search for specific genres or topics.</p><p>In this role, consider these critical business challenges:</p><ul><li><strong>Can we develop a system that automatically presents each manager with the specific data relevant to their department, eliminating the need for manual filtering?</strong></li><li><strong>Is it possible to dynamically tailor the information displayed based on which department is accessing it?</strong></li><li><strong>How can we identify and highlight any inaccuracies in the data to maintain the integrity of our reports?</strong></li></ul><p>DAX Information Functions provide the tools to build efficient, responsive, and accurate systems, much like a sophisticated library catalog that guides staff to the right resources based on their specific needs. Let’s explore how these functions can transform your data management, making it as effective as a well-organized library.</p><p>Based on the functions available till Sep 2024 we can categorize it based on their core functionalities like below :</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*P206x6M0fFCEte22zpvnEw.png" /></figure><h3>1. Data Integrity and Validation Functions:</h3><h3>Data Type and Value Checks:</h3><p>Think of organizing a library where you have a system to manage where each book belongs. Each book is categorized not only by fiction or non-fiction but also by its specific genre, such as mystery, science fiction, or biography.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*fG4nAq1yqKh4KFPO" /><figcaption>Photo by <a href="https://unsplash.com/@christinhumephoto?utm_source=medium&amp;utm_medium=referral">Christin Hume</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><ul><li><strong>Is it an error?</strong> (ISERROR()): Imagine finding a cookbook mistakenly placed in the mystery section. This function checks for such mismatches or errors.</li><li><strong>Is it empty?</strong> (ISBLANK()): This is like checking whether a book&#39;s information card is blank, indicating missing details.</li><li><strong>Is it a yes/no value?</strong> (ISLOGICAL()): This function would be used to check if a book is marked as either available or checked out—simple yes/no data.</li><li><strong>Is it a number?</strong> (ISNUMBER()): Ensuring that numerical data, like a book&#39;s ISBN, is correctly categorized as a number.</li><li><strong>Is it text?</strong> (ISTEXT()): Verifying that the author&#39;s name is text and not incorrectly entered as numerical values.</li><li><strong>Is it definitely not text?</strong> (ISNONTEXT()): This would be like confirming that numerical fields do not contain text descriptions.</li><li><strong>Is it an even number?</strong> (ISEVEN()): Checking if a numbered page or a book series volume is even.</li><li><strong>Is it an odd number?</strong> (ISODD()): Similar to the above, but checking for odd numbers instead.</li></ul><h3>Existence and Inclusion:</h3><p>Now, imagine that you’re ensuring every specific book is in its correct spot and seeing if anything is missing from a collection.</p><ul><li><strong>Does this belong here?</strong> (CONTAINS()): This function helps in checking if a particular book (like a rare first edition) is in the special collections section where it belongs.</li><li><strong>Is this row here?</strong> (CONTAINSROW()): It&#39;s like looking for a complete record—for instance, ensuring that a new acquisition has been fully logged with all its details (title, author, ISBN) in the library database.</li><li><strong>Is this part of the text here?</strong> (CONTAINSSTRING()): Useful for searching through book descriptions or titles for specific keywords, like finding all titles containing &quot;Sherlock Holmes.&quot;</li><li><strong>Is this exact text here?</strong> (CONTAINSSTRINGEXACT()): This is for precise searches, like finding a book titled &quot;The Great Gatsby&quot; and not just any book with &quot;Great&quot; in the title.</li></ul><h3>2. Context and Filtering:</h3><h4>Filter and Context Analysis:</h4><ul><li><strong>HASONEFILTER()</strong>: Imagine you’re checking if only one specific genre, like mystery, is selected in the library catalog. This function confirms if only one filter is applied to a column.</li><li><strong>HASONEVALUE()</strong>: This is like verifying if there’s exactly one book by a specific author available in a search result, not multiple.</li><li><strong>ISCROSSFILTERED()</strong>: Consider how different sections of the library influence each other. For instance, if a particular author is highlighted in a display, does it affect the visibility of related books in other genres? This function checks if a column is being filtered as a result of a relationship with another table.</li><li><strong>ISFILTERED()</strong>: Similar to checking whether a specific filter, like a publication year range, is actively narrowing down the list of books visible in a search.</li><li><strong>ISINSCOPE()</strong>: Useful in complex hierarchical reports. Imagine assessing if the current view is focusing on a particular genre within a broader category, like detective novels within mysteries.</li></ul><h4>Measure Context:</h4><ul><li><strong>ISSELECTEDMEASURE()</strong>: This function determines if a specific measure (like total books checked out) is currently active or being analyzed in a report.</li><li><strong>SELECTEDMEASURE()</strong>: Imagine being able to dynamically reference whichever count is being looked at, whether it’s books checked out or books on hold, without specifying which one in advance.</li><li><strong>SELECTEDMEASUREFORMATSTRING()</strong>: This helps apply consistent formatting across different data types, similar to ensuring all numerical values in a report (like book counts or dates) are displayed with the same number of decimal places or date format.</li><li><strong>SELECTEDMEASURENAME()</strong>: If you switch between viewing different statistics, like total pages read versus total books loaned, this function dynamically updates to show the name of the statistic currently in use.</li><li><strong>ISSUBTOTAL()</strong>: This checks if the current view is a summary, like seeing the total number of books in all mystery sections combined, rather than detailed data from individual shelves.</li></ul><h3>3. User and Environment Context:</h3><p>These functions relate to understanding who is interacting with the data and under what cultural or environmental settings.</p><ul><li><strong>User Identification</strong>: USERNAME(), USEROBJECTID(), and USERPRINCIPALNAME() are like library cards that uniquely identify each library visitor. USERNAME() is the name on the card, USEROBJECTID() could be a unique barcode, and USERPRINCIPALNAME() might be the official name or ID used for logging into library computers.</li><li><strong>User Settings</strong>: USERCULTURE() and CUSTOMDATA() are A library card with a name or ID, representing the unique identity of the user. to understanding a visitor&#39;s language preference or any special instructions they might have noted on their library account. USERCULTURE() helps in determining if they prefer books in English or another language, while CUSTOMDATA() could be any specific needs they&#39;ve registered, like accessibility requirements.</li></ul><h3>4. Table and Data Structure Analysis:</h3><p>These functions are about examining the contents and structure of the data ‘library’ itself.</p><ul><li><strong>Data Overview</strong>: COLUMNSTATISTICS() is like an index card summarizing the contents of a bookshelf, giving insights like the number of books, the average age of books, or the most commonly found genres.</li><li><strong>Data Presence</strong>: ISEMPTY() checks if a shelf or a section of the library is empty, ensuring there are books or resources available before directing someone there.</li><li><strong>Data Visibility</strong>: NONVISUAL() determines if certain books are meant to be referenced but not available for public display, like rare manuscripts that are only listed in the catalog for scholarly reference but not for checkout.</li></ul><h3>5. Sequence Logic:</h3><p>These functions handle the order or timing of data, much like organizing and referencing chronological or sequential data in a library.</p><ul><li><strong>Order Verification</strong>: ISAFTER() and ISONORAFTER() are like checking a timeline in a history book. ISAFTER() verifies if one event (like a historical battle) happened after another. ISONORAFTER() checks if an event occurred after or precisely at the same time as another, useful for aligning historical events accurately.</li></ul><h3>References:</h3><ul><li><a href="https://learn.microsoft.com/en-us/dax/information-functions-dax">Information functions (DAX) - DAX</a></li><li><a href="https://dax.guide/functions/information/">Information - DAX Guide</a></li></ul><blockquote>Don’t forget to subscribe to</blockquote><blockquote>👉 <a href="https://medium.com/microsoft-power-bi">Power BI Publication</a></blockquote><blockquote>👉 <a href="https://medium.com/microsoft-power-bi/newsletters/microsoft-power-bi-weekly">Power BI Newsletter</a></blockquote><blockquote>and join our Power BI community:</blockquote><p><a href="https://linktr.ee/powerbi.masterclass">Microsoft Power BI Masterclass | Linktree</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=b2653c9bd73a" width="1" height="1" alt=""><hr><p><a href="https://medium.com/microsoft-power-bi/dax-mastery-information-functions-day-9-b2653c9bd73a">DAX Mastery: Information Functions (Day 9)</a> was originally published in <a href="https://medium.com/microsoft-power-bi">Power BI</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[DAX Mastery: Text Functions (Day 8)]]></title>
            <link>https://medium.com/microsoft-power-bi/dax-mastery-text-functions-day-8-7dc5fd127e74?source=rss-abc22cecd66f------2</link>
            <guid isPermaLink="false">https://medium.com/p/7dc5fd127e74</guid>
            <category><![CDATA[power-bi]]></category>
            <category><![CDATA[data-analytics]]></category>
            <category><![CDATA[dax]]></category>
            <category><![CDATA[business-intelligence]]></category>
            <category><![CDATA[data-analysis]]></category>
            <dc:creator><![CDATA[Data Intelligence Hub]]></dc:creator>
            <pubDate>Mon, 12 Aug 2024 17:52:34 GMT</pubDate>
            <atom:updated>2024-09-15T08:27:10.775Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/922/1*Di1nB2I7PzqXjJVyFJZVog.png" /></figure><p>Imagine you’re preparing a crucial end-of-quarter report with data from multiple regions. The dataset includes customer reviews, product descriptions, and sales records, all entered inconsistently — some with extra spaces, others in all caps, mismatched product codes, and even special characters that need to be cleaned up. You’ve spent hours trying to clean up the messy text data, only to realize it still doesn’t look right. Without the right tools, sorting through this information to find actionable insights would be incredibly challenging.</p><p>This is where the power of DAX text functions comes into play. These functions allow us to clean, format, and analyze text data effectively, ensuring that our reports and analyses are both accurate and easy to understand.</p><p>Based on the functions available so far, we can divide them into the following categories:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*P13OxMPOjRvflZgpJTlP5A.png" /></figure><h3>1. Data Cleaning</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*Plm2yMiUpWmIuRrY" /><figcaption>Photo by <a href="https://unsplash.com/@towfiqu999999?utm_source=medium&amp;utm_medium=referral">Towfiqu barbhuiya</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><p>Data cleaning is an essential first step when preparing your text data for analysis. It involves removing unwanted characters, fixing formatting issues, and ensuring consistency across your dataset.</p><ul><li><strong>Whitespace and Text Management</strong>: Functions like TRIM and CLEAN help you get rid of unnecessary spaces and non-printable characters, making your text data neat and tidy.</li></ul><pre>Example : TRIM(&quot;  Product-12345  &quot;)<br><br>Output  : &quot;Product-12345&quot;</pre><pre>Example : CLEAN(&quot;Product-12345&quot; &amp; CHAR(160))<br><br>Output  : &quot;Product-12345&quot;</pre><blockquote>Use TRIM when dealing with extra spaces at the beginning or end of a string. Use CLEAN when your data contains non-printable characters, such as those that can appear in data copied from web pages or PDFs.</blockquote><ul><li><strong>Text Replacement</strong>: With REPLACE and SUBSTITUTE, you can easily swap out specific portions of text, such as correcting common spelling mistakes or updating old product codes.</li></ul><pre>Example : SUBSTITUTE(&quot;Product-12345&quot;, &quot;Product&quot;, &quot;Item&quot;)<br><br>Output  : &quot;Item-12345&quot;</pre><pre>Example : REPLACE(&quot;Product-12345&quot;, 1, 7, &quot;Item&quot;)<br><br>Output  : &quot;Item-12345&quot;</pre><blockquote>Use SUBSTITUTE to replace all instances of a specific word or character within a string. Use REPLACE when you know the exact position and length of the segment you need to replace.</blockquote><ul><li><strong>Number Formatting</strong>: The FIXED function lets you format numbers as text, often used to standardize decimal places in reports.</li></ul><pre>Example : FIXED(1234.5678, 2)<br><br>Output  : &quot;1234.57&quot;</pre><h3>2. Text Parsing</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*MS8REqN_NflQmLxZ" /><figcaption>Photo by <a href="https://unsplash.com/@deactivated?utm_source=medium&amp;utm_medium=referral">Deactivated Account</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><p>Text parsing is all about extracting meaningful information from your data. This could mean pulling out specific substrings, finding the position of certain characters, or simply measuring the length of a string.</p><ul><li><strong>Substring Operations</strong>: Functions like LEFT, RIGHT, and MID allow you to extract specific parts of a string. This is particularly useful when dealing with standardized codes or identifiers.</li></ul><pre>Example : LEFT(&quot;Product-12345&quot;, 7)<br><br>Output  : &quot;Product&quot;</pre><ul><li><strong>Text Searching and Length</strong>: FIND and SEARCH help locate specific text within a string, while LEN tells you the length of the text, which can be useful for data validation.</li></ul><pre>Example : FIND(&quot;-&quot;, &quot;Product-12345&quot;, 1)<br><br>Output  : 8</pre><pre>Example : SEARCH(&quot;product&quot;, &quot;Product-12345&quot;, 1)<br><br>Output  : 1</pre><blockquote>Use FIND when you need to locate the exact position of a substring in a case-sensitive manner. Use SEARCH for case-insensitive searches.</blockquote><pre>Example : LEN(&quot;Product-12345&quot;)<br><br>Output  : 12</pre><h3>3. Text Formatting</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*aL1tPKzj7LaMm2o5" /><figcaption>Photo by <a href="https://unsplash.com/@lucasgwendt?utm_source=medium&amp;utm_medium=referral">Lucas George Wendt</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><p>Text formatting ensures that your data is presented consistently, which is crucial for clear communication in your reports and dashboards.</p><ul><li><strong>Case and Format Conversion</strong>: UPPER and LOWER allow you to standardize the case of text strings, while FORMAT and VALUE convert numbers to text and vice versa.</li></ul><pre>Example : UPPER(&quot;product-12345&quot;)<br><br>Output  : &quot;PRODUCT-12345&quot;</pre><pre>Example : FORMAT(DATE(2024, 8, 12), &quot;MMM DD, YYYY&quot;)<br><br>Output  : &quot;Aug 12, 2024&quot;</pre><pre>Example : VALUE(&quot;1234.56&quot;)<br><br>Output  : 1234.56</pre><h3>4. Text Construction</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*-w5h9AsZtGU3xWAC" /><figcaption>Photo by <a href="https://unsplash.com/@profwicks?utm_source=medium&amp;utm_medium=referral">Ben Wicks</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><p>Text construction involves combining multiple text strings into one, which is often necessary when creating labels, building custom identifiers, or concatenating fields in your reports.</p><ul><li><strong>Concatenation</strong>: The CONCATENATE and COMBINEVALUES functions let you join two or more text strings together, creating custom labels or IDs that bring different pieces of information into a single, readable format.</li></ul><pre>Example : CONCATENATE(&quot;Product-&quot;, &quot;12345&quot;)<br><br>Output  : &quot;Product-12345&quot;</pre><pre>Example : COMBINEVALUES(&quot;-&quot;, &quot;Product&quot;, &quot;12345&quot;)<br><br>Output  : &quot;Product-12345&quot;</pre><blockquote>Use CONCATENATE for simple text combinations. Use COMBINEVALUES when you need to join multiple strings with a separator, especially when creating identifiers or labels.</blockquote><ul><li><strong>Iterative Concatenation</strong>: CONCATENATEX goes a step further by allowing you to concatenate the results of an expression evaluated for each row in a table, making it a powerful tool for more complex text operations.</li></ul><pre>Example : CONCATENATEX(Products, Products[ProductName], &quot;, &quot;)<br><br>Output  : &quot;ProductA, ProductB, ProductC&quot;</pre><h3>5. Special Characters</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/554/0*sYSCiXcjVPhx6mW9.png" /></figure><p>Sometimes, your data involves special characters that need to be handled carefully, whether it’s adding specific symbols or working with Unicode characters.</p><ul><li><strong>Character Operations</strong>: Functions like UNICHAR and UNICODE help you work with special characters, allowing you to incorporate them into your data in meaningful ways.</li></ul><pre>Example : UNICHAR(169)<br><br>Output  : &quot;©&quot;</pre><pre>Example : UNICODE(&quot;A&quot;)<br><br>Output  : 65</pre><ul><li><strong>Text Repetition</strong>: REPT lets you repeat a text string a specified number of times, useful for creating visual effects or emphasizing certain data points in your reports.</li></ul><pre>Example : REPT(&quot;*&quot;, 5)<br><br>Output  : &quot;*****&quot;</pre><h3>References:</h3><ul><li><a href="https://learn.microsoft.com/en-us/dax/text-functions-dax">Text functions (DAX) - DAX</a></li><li><a href="https://dax.guide/functions/text/">Text - DAX Guide</a></li></ul><p>Click below link for next part:</p><p><a href="https://shrikanth-hebbar.medium.com/dax-mastery-information-functions-day-9-b2653c9bd73a">DAX Mastery: Information Functions (Day 9)</a></p><blockquote>Don’t forget to subscribe to</blockquote><blockquote>👉 <a href="https://medium.com/microsoft-power-bi">Power BI Publication</a></blockquote><blockquote>👉 <a href="https://medium.com/microsoft-power-bi/newsletters/microsoft-power-bi-weekly">Power BI Newsletter</a></blockquote><blockquote>and join our Power BI community</blockquote><blockquote>👉 <a href="https://linktr.ee/powerbi.masterclass">Power BI Masterclass</a></blockquote><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=7dc5fd127e74" width="1" height="1" alt=""><hr><p><a href="https://medium.com/microsoft-power-bi/dax-mastery-text-functions-day-8-7dc5fd127e74">DAX Mastery: Text Functions (Day 8)</a> was originally published in <a href="https://medium.com/microsoft-power-bi">Power BI</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[DAX Mastery: Logical Functions (Day 7)]]></title>
            <link>https://medium.com/microsoft-power-bi/dax-mastery-logical-functions-day-7-ca344fd2c6df?source=rss-abc22cecd66f------2</link>
            <guid isPermaLink="false">https://medium.com/p/ca344fd2c6df</guid>
            <category><![CDATA[business-intelligence]]></category>
            <category><![CDATA[power-bi-tutorials]]></category>
            <category><![CDATA[dax]]></category>
            <category><![CDATA[power-bi]]></category>
            <category><![CDATA[data-analysis]]></category>
            <dc:creator><![CDATA[Data Intelligence Hub]]></dc:creator>
            <pubDate>Wed, 07 Aug 2024 13:17:50 GMT</pubDate>
            <atom:updated>2024-08-12T17:55:59.348Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/842/1*7ssoMfZQXw2wnRktHEgTPQ.png" /></figure><p>Imagine waking up to a sky covered in dark clouds. You’re heading out for a walk and unsure if you should take an umbrella.</p><p>You check if it’s raining; if it is, the umbrella is a must. Even if it’s not raining but the sky appears stormy, you might take it just in case. On cautious days, you decide to bring it if it’s either raining or cloudy. But on days when you’re feeling confident, you decide not to take the umbrella unless it’s actually raining.</p><p>You could also rely on predictions. If the forecast suggests a high chance of rain, you take the umbrella. Depending on the type of rain — drizzle or storm — you pick the right umbrella from your collection. Sometimes, you’re so confident in the forecast that you decide early on, even before checking outside.</p><p>Yet, things don’t always go as planned. Maybe the umbrella breaks, but you have a backup plan — like borrowing one from a friend. And on rare occasions, when you can’t find your umbrella, you grab whatever you can to stay dry, because something is better than nothing.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*3LjXwkdQklPx3ht0" /><figcaption>Photo by <a href="https://unsplash.com/@jonatron?utm_source=medium&amp;utm_medium=referral">Jon Ly</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><p>Now, let’s bring this scenario into the world of DAX. The decisions made about whether to take an umbrella, based on various weather conditions, are analogous to how logical functions operate in DAX. Each decision — whether to bring the umbrella depending on whether it’s raining or what the forecast predicts ,mirrors the functionality of different logical operations in DAX like below —</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*uAp6pqXPktCurLFEJGGEWw.png" /></figure><p>Based on the functions available so far, we can divide them into the following categories:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*jKeOQ7PZbnSs2AoLTjioCQ.png" /></figure><h3>1. Basic Logical Functions</h3><ul><li><strong>AND( )</strong>: The AND function is used when you need to check if multiple conditions are true simultaneously. If all specified conditions are true, AND returns true; otherwise, it returns false.</li></ul><pre>Example : AND(1 &lt; 10, 10 &gt; 5)<br><br>Output  : TRUE</pre><p>The function returns TRUE because both conditions (1 &lt; 10 and 10 &gt; 5) are true.</p><ul><li><strong>OR( )</strong>: The OR function is used when you need to check if at least one of multiple conditions is true. OR returns true if any of the specified conditions are true.</li></ul><pre>Example : OR(1 &lt; 10, 10 &lt; 5)<br><br>Output  : TRUE</pre><p>The first condition 1 &lt; 10 is TRUE, and since OR returns TRUE if any one of the conditions is TRUE, the result is TRUE.</p><ul><li><strong>NOT( )</strong>: The NOT function is used to reverse the outcome of a condition. If the condition is true, NOT returns false, and if the condition is false, NOT returns true.</li></ul><pre>Example : NOT(1 &lt; 10)<br><br>Output  : FALSE</pre><p>The function returns FALSEbecause the condition (1 &lt; 10) is true, and NOT reverses it.</p><h3>2. Boolean Values</h3><ul><li><strong>TRUE() and FALSE()</strong>: TRUE and FALSE functions are used to represent and return Boolean values in DAX. TRUE is used when a condition is met, and FALSE is used when it is not.</li></ul><pre>Example : IF(1 &lt; 10, TRUE(), FALSE())<br><br>Output  : TRUE</pre><p>The function returns TRUEbecause the condition (1 &lt; 10) is true.</p><h3>3. Basic Conditional Functions</h3><ul><li><strong>IF( )</strong>: The IF function is used to create conditional logic. It evaluates a condition and returns one value if the condition is true and another if it is false.</li></ul><pre>Example : IF(1 &lt; 10, &quot;Less&quot;, &quot;More&quot;)<br><br>Output  : &quot;Less&quot;</pre><p>The function returns Lessbecause the condition (1 &lt; 10) is true.</p><ul><li><strong>IF.EAGER( )</strong>: The IF.EAGER function is used similarly to the IF function, where it evaluates a condition and returns one value if the condition is true and another if it is false. However, the key difference is that IF.EAGER evaluates all conditions up front, which can improve performance in complex calculations.</li></ul><pre>Example : IF.EAGER(1 &lt; 10, &quot;Less&quot;, &quot;More&quot;)<br><br>Output  : &quot;Less&quot;</pre><p>The function returns Lessbecause the condition (1 &lt; 10) is true, evaluating all conditions upfront.</p><blockquote>The main difference between IF and IF.EAGER lies in how they process the evaluation. While IF may process conditions as they are needed (lazily), IF.EAGER evaluates all conditions immediately (eagerly). This can lead to performance improvements, especially in complex calculations, but in simpler cases like this, both functions will yield the same result.</blockquote><ul><li><strong>SWITCH( )</strong>: The SWITCH function is used when you have multiple conditions to evaluate, and you want to return different results based on those conditions.</li></ul><pre>Example : SWITCH(10, 1, &quot;One&quot;, 10, &quot;Ten&quot;, &quot;Other&quot;)<br><br>Output  : &quot;Ten&quot;</pre><p>The function returns Tenbecause the value 10 matches the second condition.</p><blockquote>SWITCH is more efficient than multiple nested IF statements and better in reading it. Consider below example:</blockquote><pre>IF(Score = 1, &quot;Poor&quot;, <br>IF(Score = 2, &quot;Below Average&quot;, <br>IF(Score = 3, &quot;Average&quot;, <br>IF(Score = 4, &quot;Good&quot;, <br>IF(Score = 5, &quot;Excellent&quot;, &quot;Unknown&quot;)))))</pre><pre>SWITCH(Score, <br>1, &quot;Poor&quot;, <br>2, &quot;Below Average&quot;, <br>3, &quot;Average&quot;, <br>4, &quot;Good&quot;, <br>5, &quot;Excellent&quot;, &quot;Unknown&quot;)</pre><blockquote>In the nested IF statements, each condition is evaluated one after the other, which can be harder to read and manage, especially with many conditions. As the conditions grow, the nested structure becomes more complex and prone to errors.</blockquote><blockquote>On the other hand, SWITCH handles all the conditions in a flat, straightforward manner, making the code easier to read, manage, and less prone to mistakes. SWITCH evaluates the expression once and directly returns the matching result, which is more efficient than evaluating multiple nested IF conditions.</blockquote><h3>4. Error Handling</h3><ul><li><strong>IFERROR( )</strong>: The IFERROR function is used to handle errors in your calculations. It returns a specified value if an error occurs, ensuring that your analysis continues without interruption.</li></ul><pre>Example : IFERROR(10/0, &quot;Error occurred&quot;)<br><br>Output  : &quot;Error occurred&quot;</pre><p>The function returns Error occurredbecause dividing by zero causes an error.</p><h3>5. Bitwise Logical Functions</h3><ul><li><strong>BITAND()</strong>, <strong>BITOR()</strong>, <strong>BITXOR()</strong>: These functions are used for performing bitwise operations on integers, useful for low-level data manipulation and comparisons.</li></ul><pre>Example : BITAND(1, 10)<br><br>Output  : 0</pre><p>The BITAND function compares the binary representation of 1 (0001) and 10 (1010). For each bit, it returns 1 only if both corresponding bits are 1; otherwise, it returns 0. In this case, no bits match in both numbers, so the result is 0000, which is 0 in decimal.</p><pre>Example : BITOR(1, 10)<br><br>Output  : 11</pre><p>The for BITORresult is 1011, where the bits from both numbers are combined.</p><ul><li><strong>Output</strong>: 1011 in binary, which is 11 in decimal.</li></ul><pre>Example : BITXOR(1, 10)<br><br>Output  : 11</pre><ul><li>The BITXOR function compares the binary representation of 1 (0001) and 10 (1010). For each bit, it returns 1 only if the corresponding bits in the two numbers are different (i.e., one is 1 and the other is 0). In this case, the result is 1011, where the bits that differ between the two numbers are set to 1.</li><li><strong>Output</strong>: 1011 in binary, which is 11 in decimal.</li></ul><p><strong>BITLSHIFT()</strong>: The BITLSHIFT function shifts the bits of a number to the left by a specified number of positions, effectively multiplying the number by 2 raised to the power of the number of positions.</p><pre>Example : BITLSHIFT(1, 2)<br><br>Output  : 4</pre><p>Shifts the binary representation of 1 (0001) two positions to the left, resulting in 0100, which is 4 in decimal</p><ul><li><strong>BITRSHIFT()</strong>: The BITRSHIFT function shifts the bits of a number to the right by a specified number of positions, effectively dividing the number by 2 raised to the power of the number of positions.</li></ul><pre>Example : BITRSHIFT(10, 1)<br><br>Output  : 5</pre><p>Shifts the binary representation of 10 (1010) one position to the right, resulting in 0101, which is 5 in decimal.</p><h3>6. Null Handling</h3><ul><li><strong>COALESCE( )</strong>: The COALESCE function is used to return the first non-blank value from a list of arguments. It is particularly useful for handling missing or null data.</li></ul><pre>Example : COALESCE(BLANK(), 0)<br><br>Output  : 0</pre><p>The function returns 0because it selects the first non-blank value from the list of arguments.</p><h3>References:</h3><ul><li><a href="https://learn.microsoft.com/en-us/dax/logical-functions-dax">Logical functions (DAX) - DAX</a></li><li><a href="https://dax.guide/functions/logical/">Logical - DAX Guide</a></li></ul><p>Click below link for next part:</p><p><a href="https://shrikanth-hebbar.medium.com/dax-mastery-text-functions-day-8-7dc5fd127e74">DAX Mastery: Text Functions (Day 8)</a></p><blockquote>Don’t forget to subscribe to</blockquote><blockquote>👉 <a href="https://medium.com/microsoft-power-bi">Power BI Publication</a></blockquote><blockquote>👉 <a href="https://medium.com/microsoft-power-bi/newsletters/microsoft-power-bi-weekly">Power BI Newsletter</a></blockquote><blockquote>and join our Power BI community</blockquote><blockquote>👉 <a href="https://linktr.ee/powerbi.masterclass">Power BI Masterclass</a></blockquote><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=ca344fd2c6df" width="1" height="1" alt=""><hr><p><a href="https://medium.com/microsoft-power-bi/dax-mastery-logical-functions-day-7-ca344fd2c6df">DAX Mastery: Logical Functions (Day 7)</a> was originally published in <a href="https://medium.com/microsoft-power-bi">Power BI</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[DAX Mastery: Time Intelligence Functions (Day 6)]]></title>
            <link>https://medium.com/microsoft-power-bi/dax-mastery-time-intelligence-functions-day-6-6d1a2d0f6f12?source=rss-abc22cecd66f------2</link>
            <guid isPermaLink="false">https://medium.com/p/6d1a2d0f6f12</guid>
            <category><![CDATA[power-bi]]></category>
            <category><![CDATA[power-bi-tutorials]]></category>
            <category><![CDATA[business-intelligence]]></category>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[dax]]></category>
            <dc:creator><![CDATA[Data Intelligence Hub]]></dc:creator>
            <pubDate>Sun, 04 Aug 2024 18:17:19 GMT</pubDate>
            <atom:updated>2024-08-07T13:21:53.751Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/845/1*lFukCIO5XM1zin68bYw_3A.png" /></figure><p>In the fast-paced world of business, staying ahead means more than just tracking numbers — it requires a deep understanding of how performance evolves over time.</p><p>For many tasks,Date and Timefunctions in DAX which was discussed in previous post are more than sufficient. They are incredibly useful for “organizing and structuring” your data, enabling us to handle general date and time manipulations with ease.</p><p>However, when it comes to more complex time-based tasks — like comparing performance across different years, tracking progress within the current quarter, or spotting trends over time — the limitations of basic Date and Timefunctions become clear. This is where DAX’s Time Intelligencefunctions comes to play. These advanced functions allows us to analyze data over various time periods, uncover trends, compare year-over-year performance, and make better decisions that drive growth. Whether you’re measuring progress this quarter or comparing this year to the last, Time Intelligence functions help turn raw data into meaningful insights.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*RS4wa5UjpUXI9hIiuxV7FA.png" /><figcaption>Key Differences between “Date and Time” and “Time Intelligence”</figcaption></figure><p>With around ~35 DAX functions specifically related to time intelligence as of August 2024, understanding them can be challenging. To make it easier, lets group these functions by their core functionality as below:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*9AY1N91p9yjfdEgSRh2fsg.png" /><figcaption>Functions related to Time Intelligence</figcaption></figure><h3>1. Start/End Dates Functions:</h3><p>In time-based data analysis, knowing the exact start or end of a period is essential. Start/End Dates Functions quickly guide you to the first or last day of any month, quarter, or year, helping you accurately frame your analysis.</p><ul><li><strong>STARTOFMONTH, STARTOFQUARTER, STARTOFYEAR</strong>: These functions take you straight to the first day of a month, quarter, or year. It’s like flipping to the first page of your calendar to see where the period begins.</li><li><strong>ENDOFMONTH, ENDOFQUARTER, ENDOFYEAR</strong>: Similarly, these functions help you find the last day of any month, quarter, or year. Think of them as flipping to the last page of your calendar to see how things wrapped up.</li></ul><h3>2. Time Aggregation Functions:</h3><p>When you need to summarize data over specific periods, Time Aggregation Functions are your tools. They help you calculate totals or balances for the month-to-date, quarter-to-date, or year-to-date, giving you a clear view of your data as it progresses through time.</p><ul><li><strong>TOTALMTD, TOTALQTD, TOTALYTD</strong>: These functions calculate the running total for the month, quarter, or year up to the current date. It’s like keeping a tally as the period progresses.</li><li><strong>CLOSINGBALANCEMONTH, CLOSINGBALANCEQUARTER, CLOSINGBALANCEYEAR</strong>: These functions evaluate your data at the end of the month, quarter, or year, giving you a snapshot of your totals at the closing of each period.</li><li><strong>OPENINGBALANCEMONTH, OPENINGBALANCEQUARTER, OPENINGBALANCEYEAR</strong>: These do the opposite — they assess your data at the very start of the month, quarter, or year, providing a starting point for your analysis.</li></ul><h3>3. Date Selection Functions:</h3><p>Date Selection Functions help you pinpoint specific dates within your data. Whether you need the first or last date in a set, or the first and last non-blank dates, these functions make sure you’re looking at the right time points.</p><ul><li><strong>FIRSTDATE, LASTDATE</strong>: These functions find the very first or last date in your selected data range, ensuring you’re starting or ending at the right spot.</li><li><strong>FIRSTNONBLANK, LASTNONBLANK</strong>: These are like the previous functions, but they ignore any empty dates, jumping straight to the first or last date with actual data.</li></ul><h3>4. Time Period Functions:</h3><p>Time Period Functions let you navigate through time effortlessly, moving between previous and next periods, or comparing the same period across different years.</p><ul><li><strong>PREVIOUSDAY, PREVIOUSMONTH, PREVIOUSQUARTER, PREVIOUSYEAR</strong>: These functions shift your focus back to the previous day, month, quarter, or year, helping you compare past performance.</li><li><strong>NEXTDAY, NEXTMONTH, NEXTQUARTER, NEXTYEAR</strong>: These do the opposite, moving you forward in time to the next day, month, quarter, or year, perfect for future planning.</li><li><strong>SAMEPERIODLASTYEAR</strong>: This function compares your current data with the same period in the previous year, letting you track year-over-year changes.</li></ul><h3>5. Custom Date Functions:</h3><p>Custom Date Functions give you flexibility in your date calculations, allowing you to shift dates, extract specific ranges, or analyze data over custom time frames.</p><ul><li><strong>DATEADD, PARALLELPERIOD</strong>: These functions let you shift dates forward or backward, or create parallel time periods, giving you custom time frames to analyze</li><li><strong>DATESBETWEEN, DATESINPERIOD</strong>: Need a specific date range? These functions create custom date ranges based on your criteria, helping you focus on the exact period you want to analyze.</li><li><strong>DATESMTD, DATESQTD, DATESYTD</strong>: These functions return the dates for the month-to-date, quarter-to-date, or year-to-date, giving you a ready-made range for your analysis.</li></ul><h3>References:</h3><ul><li><a href="https://learn.microsoft.com/en-us/dax/time-intelligence-functions-dax">Time intelligence functions (DAX) - DAX</a></li><li><a href="https://dax.guide/functions/time-intelligence/">Time Intelligence - DAX Guide</a></li></ul><p>Click below link for next part:</p><p><a href="https://shrikanth-hebbar.medium.com/dax-mastery-logical-functions-day-7-ca344fd2c6df">DAX Mastery: Logical Functions (Day 7)</a></p><blockquote>Don’t forget to subscribe to</blockquote><blockquote>👉 <a href="https://medium.com/microsoft-power-bi">Power BI Publication</a></blockquote><blockquote>👉 <a href="https://medium.com/microsoft-power-bi/newsletters/microsoft-power-bi-weekly">Power BI Newsletter</a></blockquote><blockquote>and join our Power BI community</blockquote><blockquote>👉 <a href="https://linktr.ee/powerbi.masterclass">Power BI Masterclass</a></blockquote><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=6d1a2d0f6f12" width="1" height="1" alt=""><hr><p><a href="https://medium.com/microsoft-power-bi/dax-mastery-time-intelligence-functions-day-6-6d1a2d0f6f12">DAX Mastery: Time Intelligence Functions (Day 6)</a> was originally published in <a href="https://medium.com/microsoft-power-bi">Power BI</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
    </channel>
</rss>