DAX provides support to follow this relationship through functions such as RELATED and RELATEDTABLE. Date and time functions. days, weeks, months) and the columns you want to include in your table. The SELECTEDVALUE function simplifies the syntax required when you use a numeric column of an entity as a parameter in a calculation. As your DAX skills improve, you will create formulas using many different functions. DAX CountX. FILTER can filter rows from a table by using any expression valid in the row context. If you’re familiar with functions in Excel formulas, many of the functions in DAX will appear similar to you; however, DAX functions are unique in the following ways: The Power BI RELATED function is a Relationship function under DAX (Data Analysis Expressions) function used to retrieve a single value from a related table based on a defined relationship. In contrast to Microsoft Excel, which stores dates as a serial number, DAX date functions always return a datetime data type. . When DAX RELATED function performs a lookup, it examines all values in the specified table regardless of any filters that may have been applied. In this article, we focus on a simple description of the function and its main use cases. As you can see, there is a large amount of code duplicated for the two columns. Other related topics: Pre dictive Analytics; Power BI Embedded; Power BI Governance; Power BI Training . In other words, the function doesn't return a lookup value if only some of the criteria match. You can obtain a blank value in DAX calling the BLANK function. In addition to running totals, rolling totals, month-to-date, quarter-to-date, year-to-date, and averages, window. The use of this parameter is not recommended. Return value. The historical DAX function that aggregates and group data leveraging existing relationships is SUMMARIZE. We have several types of Text Functions in DAX, below is the table. Therefore, while the RELATED output is one unique value, the output of the RELATEDTABLE function is a. Relevant DAX functions Relationship evaluation Next steps This article targets import data modelers working with Power BI Desktop. As your DAX skills improve, you will create formulas using many different functions. They return one or more values and are used to solve data analysis problems, creating a new relationship between different data variables. ”. Here's a step-by-step guide: Identify the scenario where you need to use the ALL function to ignore filters. The RELATED function is a key component of the Data Analysis Expressions (DAX) language in Power BI, which enables users to establish relationships. The column 'People [FullName]' either doesn't exist or doesn't have a relationship to any table available in the current context. Some of the functions that you’ll encounter in the examples below are CALCULATE, FILTER, MAX, ALLSELECTED, and many more. Give measure a name as “Sales Value. In USERELATIONSHIP, the status of a relationship is not important; that is, whether the relationship is active or not does not affect the usage of the function. to create the sum of sales, follow the steps given below. Product Category AlternateKey. DAX Function แนะนำฟังก์ชัน Related. As a nested. GROUP BY permits DAX CURRENTGROUP function to be used inside aggregation functions in the extension columns that it adds. It returns a table that contains all the dates from the start of the current year to the latest available. Please visit. The. ADDMISSINGITEMS. e. As you can see, functions in DAX can help you create very powerful formulas. Other related functions are: CONCATENATEXUnderstanding the difference between LASTDATE and MAX in DAX. The RELATED DAX function is an essential feature in Power BI that allows users to establish relationships between tables. You can use the DAX DATEDIFF function third argument to select the difference value. By using the RELATED function, users can access data from. Volatile. SubRegion = RELATED ( 'Account'[SubRegion] ) RegardsBusiness Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces three DAX Time Intelligence functions related to the Start of Periods: STARTOFMONTH(), STARTOFQUARTER. IF (15 IN VALUES ('Calendar' [MonthNoIndex]) ,"Yes" ,"No" ) This little statement checks if 15 is contained in the table returned by VALUES (). This function is deprecated. Hi, I have a question about the RELATED DAX function if someone can help please. Not recommended. If function DAX. You may need to create calculated columns in the Product table using the RELATED DAX function to achieve this process. With the RELATED DAX function, financial analysts can build interactive visualizations that allow users to drill down or slice and dice data based on different dimensions or entities. RELATED(<column>) CALCULATE Function: This Function makes simple calculations of multiple variables easy. Why and when to use RELATED and its companion function RELATEDTABLE: two common DAX functions that are required when using a row. Try modifying your DAX as follows: Working Hours = IF (. These are in-depth video lectures of the Standard time-related calculations pattern. The use of this parameter is not recommended. Note: You must create a relationship to can use the RELATED DAX function. COUNTA can operate on a Boolean data type, whereas COUNT cannot do that. 1 . DAX Cheat Sheet. The COUNT function internally executes COUNTX, without any performance difference. Expressions like this are made up of various parts, such as functions, operators, and constants, all combined into a single formula and evaluated to provide a result (value or values). RELATED DAX FUNCTION First, we will be looking at the RELATED function, which requires a column name as an input and returns a related value from. Creating Time-Intelligence Functions in DAX; DAX is Microsoft’s new(ish) language which allows you to return results from data stored using the xVelocity database engine, which, unlike for most databases, stores data in columns rather than rows. Since there are many tables that have relationship to the People table, only ONE. DAX includes the following categories of functions: Date and Time, Time Intelligence, Information, Logical, Mathematical, Statistical, Text, Parent/Child, and Other functions. See Remarks and Related functions for alternatives. A volatile function may return a different result every time you call it, even if you provide the same arguments. This function is particularly useful when working with complex data models that involve multiple tables and relationships. Data Analysis Expressions (DAX) are the collection of formulas, functions, operators, and constants that allows a user to create measures, dimensions, and custom tables. Due to this. This article provides a complete explanation of the behavior of the ALLxxx functions in DAX. Define the scenarios: Clearly define the scenarios you want to analyze and the specific variables or factors that will change in each scenario. Deprecated. It allows you to access data from a related table without creating complex joins or lookups in your query. RELATED DAX function • When you have a one-to-many relationship between a fact table and a dimension table, you can use the RELATED function on the fact table many-side to perform an exact match lookup. This DAX function returns a related value from another table when it's used as a lookup function. Volatile. It provides a flexible way to transform and manipulate data within your DAX formulas. See Remarks and Related functions for alternatives. Please find the code in the below location. When used as filters in CALCULATE, ALLxxx functions might. Status = RELATED (STATUS_TYPE [STATUS_TYPE_NAME]) The above query will add a new column and updates the values with the relative values from the other table. (DAX – Power Pivot, Power BI) There are two functions in DAX with similar, and sometimes replaceable, use. When using DAX, we can use the CROSSFILTER function to change how the cross-filter direction behaves between two columns defined by a relationship. Data Analysis Expressions (DAX) is a formula expression language used in Analysis Services, Power BI, and Power Pivot in Excel. Funkce RELATED vyžaduje, aby mezi aktuální tabulkou a tabulkou existoval vztah se souvisejícími informacemi. Identify the common fields between the tables that need to be related. Strings. The value that’s returned if the logical test is TRUE. Much like the CALCULATE function described earlier, the RELATED function is very important, and you will likely use it many times. Poznámky. Column = LASTNONBLANK (SELECTCOLUMNS (RELATEDTABLE ('Interview Result'),"Status", [Final Status]),TRUE ()) Did I answer your question? Mark my post as a solution!The SUM function in DAX is an aggregation function that calculates the sum of a numeric expression for a specified column or table. Note: We can also download Power BI. This function is deprecated. Welcome back to the Power Pivot Principles blog. Dynamic pricing is a strategy that involves adjusting prices in real-time based on various factors such as demand, competition, and market conditions. DAX can be used to create measures in a number of ways. A filter predicate with a simple AND condition between two columns works faster if replaced by two filter arguments, one for each column. When filter expressions are provided, the CALCULATETABLE function modifies the filter. Deprecated. GROUP BY only works with DAX iterator functions, so it uses SUMX instead of SUM, AVERAGEX rather than AVERAGE. Deprecated. 4. Key Features of DAX Functions. RELATED and RELATEDTABLE should be used here. The RELATED function will look up the value of any other column in any other table,. 10-06-2020 12:26 PM. Related functions. text is the text in which you want to substitute characters, or a reference to a column containing text. Adds combinations of items from multiple columns to a table if they do not already exist. I always recommend using. It can only. C. These are in-depth video lectures of the Standard time-related calculations pattern. If there is no relationship between the tables, you should have a common field at least, i. Not recommended. See examples of how to use it in calculated columns, measures, and measures with filters. Since it is not an inbuilt function, the user needs to replicate it using the DAX function like the LOOKUPVALUE DAX function. It is based on establishing relationships between tables using common. Other related functions are: MAXX; MAXADAX Patterns: Related distinct count. Does not support Logical values (TRUE/FALSE values). A volatile function may return a different result every time you call it, even if you provide the same arguments. Create visualizations and reports to present the forecasted sales data in a clear and actionable manner. To implement scenario analysis with the RELATED DAX function in Power BI, it is important to follow a structured approach: 1. But while RELATED takes values from the "short" table to the "long" one (from the "number one" site of the relation to the "star" one) , RELATEDTABLE goes backwards. To learn about more Power BI topics , please subscribe to my cha. Power BI Model relationships in Power BI Desktop Article 10/27/2023 11 contributors Feedback In this article Relationship purpose Relationship properties. The RELATED function is a powerful tool that allows you to create relationships between tables and access data from related tables. The blog teaches us the 5 “ALL” related filter functions of DAX with practical examples. RELATED and LOOKUPVALUE are working similarly to. Step-3: You can change the font color white for Sales_Tag measure total, because here no need to display Text as in Total. Learn how to work with the RELATED and RELATEDTABLE function in DAXLearn SUMX - - - - My Courses - - - - ️ Maste. Learn more about CONCATENATE in the following articles: Using CONCATENATEX in measures. See Remarks and Related functions for alternatives. Fact table is joined to the dimension table through many to one relationship. 'Main' [Location] == RELATED (Indianlocations [Location]), 9, IF ('Main' [Location] == RELATED (Otherlocations [Location]), 8, 0) ) In case you want to use IN operator, try following DAX. Understanding data lineage in DAXBy using SQL Server Management Studio (SSMS), Power BI Report Builder, and open-source tools like DAX Studio, you can create and run your own DAX queries. To understand DAX functions better, one should know these features. Related articles. ** Using Iterating Functions SUMX And AVERAGEX In Power BI Working With Iterating Functions In DAX How To Use The CROSSJOIN Function. Power BI is one of the most robust and powerful business intelligence tools out there. In this case, you will be forced to use the BITWISE keyword to can get the column value, and then use the BITOR DAX function as below:. Open the LOOKUPVALUE function now. I assume history date is the extract date, so you would end up with potentially 2 date columns. The syntax for the RELATED function is: RELATED(ColumnName) Where ColumnName is the column that contains the value you want to retrieve. RELATED, RELATEDTABLE – DAX Guide. When it comes to sensitivity analysis,. COUNTA can operate on a Boolean data type, whereas COUNT cannot do that. RELATED() may also be used to refer to a column in a table related to <relation>. The RELATED DAX function is used to return a related value from another table. The RELATED function is a powerful feature of DAX that allows users to retrieve data from related tables based on established relationships. A volatile function may return a different result every time you call it, even if you provide the same arguments. This function is a shortcut for CALCULATETABLE function with no additional filters, accepting only a table reference and not a table expression. RELATED DAX Function in Power BI Demo: Using Adventure Works Data Warehouse Tables. This function is deprecated. The Region column value (for the report user) propagates to the Sales table. In our example, a calculated column that computes the year of the order would be as simple as this: 1. This. Pokud relace neexistuje, musíte vytvořit relaci. Also from a performance point of view, the engine creates two different and independent subqueries to retrieve the values of the two columns. Learn more about TREATAS in the following articles: Propagating filters using TREATAS in DAX. I get the same all the time as well. You'll learn to write. Then you can use this column for comparison in DAX. » Read more. » Read more. Interval: How you want the difference to be expressed. Returns a table with one column of dates calculated from the model automatically. The Power BI DAX DATEDIFF function returns the date difference between the start date and end date. Using RELATED function in DAX with USERELATIONSHIP. The filter and value functions in DAX are some of the most complex and powerful, and differ greatly from Excel functions. Returns a related value from another table. Not recommended. Here, we have the new SUMMARIZED table, which we have summarized based on “State” and “Category. This article shows how to use DAX and conditional formatting together to highlight the minimum and maximum values in a matrix in Power BI. Syntax RELATED ( <ColumnName> ) Return values Scalar A single value of any type. The current relationship is a many-one relationship and you are trying to use the RELATED function in the Lookup table, not in the Fact table. Learn how to use relationship functions in Data Analysis Expressions (DAX) to manage and Utilize relationships between tables. If you want to count logical values, use the COUNTAX function. It takes one argument: the name of the column in the related table to retrieve the value from. 08-14-2020 01:22 AM. Data Analysis Expressions (DAX) is a library of functions and operators that can be combined to build formulas and expressions in Power BI, Analysis Services, and Power Pivot in Excel data models. This article shows how to use the USERELATIONSHIP function in DAX to change the active relationship in a CALCULATE function. Date and time functions. ”. Get Demo Files herethis video we cover how and when to use the RELATED / RELATEDTABLE DAX functions in Power BI. Step-2: Create a calendar table using CALENDARAUTO Dax function. They return one or more values and are used to solve data analysis problems, creating a new relationship between different data variables. We really only touched on the basics of functions. This cheat sheet is your handy companion when working with DAX formulas and statements in Power BI. ADDCOLUMNS. What Is RELATED function in DAX in Power BI, When you have to refer a column in the another table in your calculation you need to use Related Function in Pow. The syntax of the RELATED function is: RELATED (<column>) where <column> is the name of a column you want to use from a related table. This article provides a complete explanation of the behavior of the ALLxxx functions in DAX. Example This formula computes the increase or decrease ratio in sales compared to the previous year. In short, when it comes to your formulas, it’s all about making them appear. The fifth variance — Filtering columns from two tables. The use of this parameter is not recommended. Some DAX functions return a table instead of a scalar, and must be wrapped in a function that evaluates the table and returns a scalar; unless the table is a single column, single row table, then it is treated as a scalar value. If you like to know more about the RELATED function, read this article. Step-2: If condition has true, Switch will return the result in form of “Low”, “Medium” & “High”. Learn more about MAXX in the following articles: Highlighting the minimum and maximum values in a Power BI matrix. . ALLSELECTED DAX function Sample Data. The ALLNOBLANKROW function only filters the blank row that a parent table, in a relationship, will show when there are one or more rows in the child table that have non-matching values to the parent column. DAX RELATED function needs a row context. g. The use of this parameter is not recommended. It is an essential function for performing advanced calculations and analysis in Power BI and other DAX-enabled platforms. Not recommended. Such a function requires a table in the first argument, which corresponds to the table that is grouped. RELATED Vs LOOKUPVALUE DAX in Power BI. Expression1 will add all the sales values, so use the SUM function to summarize the “Sale Value” column. This week, let’s discuss the difference between the RELATED and LOOKUPVALUE functions. Blank values are not skipped, if data type is Text. The name of an existing column, using standard DAX syntax. The use of this parameter is not recommended. DAX queries return results as a table right within the tool, allowing you to quickly create and test the performance of your DAX formulas. It's an important model design topic that's essential to delivering intuitive, accurate, and optimal models. The RELATED function enables users to access data from related tables using the defined. CROSSJOIN. This article shows how you can use the FILTER function to do something similar and explains the differences between the two approaches. Expression: Any expression that returns a scalar value like a column reference, integer, or string value. Jump to the Alternatives section to see the function to use. Many of the functions in DAX are similar to the Excel date and time functions. » Read more. Here, we have the new SUMMARIZED table, which we have summarized based on “State” and “Category. » Read more. RELATED(<column>) IN operator in Power BI returns either TRUE/FALSE value. . Deprecated. 2: It is the equal (=) operator which represents the beginning of the DAX syntax and also equating the two sides. Related Function. Step-2 : Create another measure to implement a nested IF condition. Related functions. Examples include sum, add, true, false, etc. Any DAX expression that returns a single scalar value, that is to be sought in columnName. New Table = SUMMARIZECOLUMNS ( 'Calendar' [Year], Sales [DateKey], FILTER ('Product','Product' [BrandName]="Contoso"),"total sales",SUM (Sales [SalesAmount] )) Please review the following blogs about how to use SUMMARIZECOLUMNS function. Jump to the Alternatives section to see the function to use. The SELECTCOLUMNS function is a Data Analysis Expressions (DAX) function that allows you to create a new table by selecting specific columns from an existing table or by defining new columns. Experiment with advanced techniques, including custom DAX expressions and calculated columns, to further refine and enrich your scenario analysis with the DISTINCT function. This can be done by selecting the "Manage Relationships" option in the "Modeling" tab and defining the relationship based on the relevant columns. It is used to establish a. A calculated column expression, where the current row context is unambiguous. (Optional) The qualified name of an existing column used to create summary groups based on the values found in it. (Optional) The value that’s returned if the logical test is FALSE. Right-click on the table and choose “New measure. Both the RELATED and LOOKUPVALUE functions in DAX work similarly to a LOOKUP function in Excel. Drop me a comment if your errors in the RELATED function still persist, I’ll help you out 🙂 . The ability to create CALCULATE filter arguments with multiple columns simplifies the DAX code and usually. Several DAX functions are useful for Power BI model relationships. Related articles. The value of result_columnName at the row where all pairs of search_columnName and search_value have an exact match. This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules. Deprecated. On the other hand, the Power BI USERELATIONSHIP specifies a relationship to be used in a specific calculation as the one that exists between columnName1 and columnName2. Returns the specified date in datetime format. It supplies comprehensive information related to the syntax, parameters, data types, and returns values for the 250+ functions stored in the DAX library. Right click on Product table and click on New column. First, we will be looking at the RELATED function, which requires a column name as an input and returns a related value from another table. Conclusion. RELATED DAX Function. The Related Function is a DAX function in Power BI that allows you to retrieve related values from a related table in the Data Model. We have a 1:* relationship between 2 tables. One of these functions is Relatedtable. ”. In today’s example, we will be using Adventure Works Data. Such a function requires a table in the first argument, which corresponds to the table that is grouped. It supplies comprehensive information related to the syntax, parameters, data types, and returns values for the 250+ functions stored in the DAX library. » Read more. Related articles. Before using any time-intelligence functions, make sure to mark one of the tables containing. The following table summarizes the variations of ALL that are provided in. So, I don't think it is used correctly here. You can create a measure as below using related function: Sales [Sales at List Price] = SUMX ( Sales, Sales [Quantity] * RELATED ( 'Product' [List Price] ) )Or try to use the LOOKUPVALUE function to retrieve the lookup value . Select table visual > format bar > field Formatting, and follow the below. Hi @edithees , It seems you are adding a custom column in Power Query Editor, but the RELATED function is used for DAX. read more. DAX includes a library of over 200 functions, operators, and constructs, providing immense flexibility in creating formulas to calculate results for just about any data analysis need. The use of this parameter is not recommended. In this category. groupBy_ColumnName. Let´s say we have table of sales of items, and table of prices of these items. Download the sample Power BI report here: RELATED. To use the RELATED function, you specify the column that contains the related value that you want. Not recommended. A more accurate way of looking at this is that RELATED lets you access the related columns of an expanded table. Luckily, in SQL 2012, DAX has been enriched with the ISFILTERED function, which lets you detect whether a column has been filtered or not. 1. » Read more. To know how to overcome the above issues and get the RELATED function work as expected and the IntelliSense list suggested columns, Please check Why the RELATED DAX function is not working in. Insert “Table” visual from the “Visualizations”. Volatile. สิ่งสำคัญของการใช้งาน Power BI ที่ขาดไม่ได้และเป็นเรื่องสำคัญมาก ๆ อย่างหนึ่งนั้นคือ DAX (Data Analysis Expressions. Not recommended. I can create a new column on table X with getting the column from table Y with RELATED function. In the dialog that opens, select the field from the first window that your tables are related on in the data model, then select your second table in the second window (the one that your RELATED function directs to),. In the AdventureWorksDW dataset, we have three tables related to Product information; DimProduct has the details of every single product;. This article explains why in many cases, MAX should be used instead of LASTDATE to search for the last date in a time period using DAX. There is always a filter context for DAX expressions. Statistical Functions: They are associated with statistical distributions and probability, such as standard deviation and number of permutations. See Remarks and Related functions for alternatives. At the very. It allows users to access data from related tables based on defined relationships. As soon as one value matches, the corresponding result is returned, and other subsequent values aren’t evaluated. Here is a step-by-step guide to help you implement the RELATED DAX function for risk assessment in Power BI: Identify the tables and data sources that contain relevant information for risk assessment. Related articles. I can create a new column on table X with getting the column from table Y with RELATED function. Not recommended. Not recommended. Drop me a comment if your errors in the RELATED function still persist, I’ll help you out 🙂 . Here's a step-by-step guide: Identify the scenario where you need to use the ALL function to ignore filters. RELATED is a DAX function used to retrieve a related value from another table. By utilizing the RELATED DAX function, you can easily retrieve the necessary data from related tables to perform variance analysis. Calculated tables are best. The expression is to be evaluated exactly once and before it is passed to the argument list. See examples below. To stay up-to-date, it is essential to monitor the latest developments and enhancements in DAX functions and related tools. A common use of this function is to set the first parameter to TRUE. Not recommended. Here I have explained each element of the syntax below: 1: It represents the name of the new measure (IncomeTaxRates2019). In this blog, we learn the 4 relationship functions of DAX with practical examples. The SELECTCOLUMNS function is commonly used in Power BI and Excel. Column = RELATED (FactTable [Key]) RELATED. Yes, the RELATED function is a type of relationship function in DAX. Most DAX functions require one or more arguments, which can include tables, columns, expressions, and. ALLSELECTED_DAX = CALCULATE ( Sum (Orders [Sales]), ALLSELECTED (Orders [Product Sub-Category])) According to the ALLSELECTED definition, by default, it. Data Analysis Expressions (DAX) are the collection of formulas, functions, operators, and constants that allows a user to create measures, dimensions, and custom tables. In this case, because the process is starting, it is the first row in the table. » 2 related articles » 1 related function. It can only. Returns the count of interval boundaries crossed between two. Indeed, you can only have one active relationship between any two tables. Aug 30, 2022. This function effectively bridges the gap between disparate tables, providing. We also. -- argument that defaults to a blank. More Power BI / DAX Tips. Returns the largest value in a column. This can be in either days, hours, minutes, months, quarters, seconds, weeks or years. See Remarks and Related functions for alternatives. After the equals sign, type r. In the previous article of this series, Andy Brown of Wise Owl Training explained how to use the oh-so-important CALCULATE function in DAX to make changes to the default filter context within a formula. A single value that is related to the current row. RELATED function is a Power BI Relationship function in DAX which returns a related value from another table. The CALCULATE function in Power BI is a key tool for performing calculations and modifying filter contexts in the data model. Jump to the Alternatives section to see the function to use. The next argument is “Search Column Name 1,” so this will. Related articles. Add the Weekly_Returns data to the Sales table by using related DAX functions. A volatile function may return a different result every time you call it, even if you provide the same arguments. Now, apply the SUMX function in Power BI. You can use this approach to create a virtual relationship. Instead of trying to use two columns from two different tables for comparison in DAX, you can use the 'RELATED` DAX function to import a column from Table A to Table B or vice-versa. COUNT and COUNTA are identical in DAX for all the data types except Boolean. It comes under Table Manipulation DAX Functions category. The RELATED DAX function in Power BI presents an incredible opportunity for organizations to unlock the true potential of their balance sheet analysis. DAX provides you with the following unique features: Measures: Measures are the dynamic expressions for calculation stored in the DAX. When used as filters in CALCULATE, ALLxxx functions might. It takes one argument: the name of the column in the related table to retrieve the value from. Step-3: As you can see in below screenshot, it return new table with given condition data where sales is > 200. This will create a simple star schema, and the DAX should be easier. DAX provides the RELATED and RELATEDTABLE which can be executed in MS Power BI, MS Power Pivot, SSAS to retrieve related data from another table. This function can be used in measures too, but as this is a tabular function, you need to wrap it in other functions to return a scalar value. In case of zero denominator, it returns its third. The DAX function reference provides detailed information including syntax, parameters, return values, and examples for each of the over 250 functions used in. The RELATED function is just one of the many DAX (Data Analysis Expressions) functions available in Power BI that enables accurate revenue forecasting. groupBy_columnName. RELATED function works between tables with a relationship established only. . » 2 related articles. You can include columns in other related tables, if one or more many-to-one relationships exist to reach the referenced. A volatile function may return a different result every time you call it, even if you provide the same arguments. We really only touched on the basics of functions. This pattern shows how to compute time-related calculations, like year-to-date, same period last year, and percentage growth using a standard calendar and relying on standard built-in time intelligence DAX functions. DAX Function แนะนำฟังก์ชัน Related. If there isn't a match that satisfies all the search values, BLANK or alternateResult (if specified) is returned. Blank values are skipped, if data type is Int. In the Weekly_Returns table, create a new calculated column named date_id in a format of yyyymmdd and use the calculated column to create a relationship to the Date table. Relationships in the data model add much flexibility, and two DAX functions thrive on this capability. This article showcases the use of CONCATENATEX, a handy DAX function to return a list of values in a measure. RELATEDTABLE: Returns the related tables filtered so that it only includes t Related articles. If a relationship does not exist, you must create a relationship. The syntax of the RELATED function is: RELATED (<column>) where <column> is the name of a column you want to use from a related table.