The RELATEDTABLE function is a powerful tool in DAX (Data Analysis Expressions) that allows you to access related tables in your data model. Right click on Product table and click on New column. Now apply the following step: The relationship will look now like this: Add a measure to TableBGrouped: 3 or more Count = CALCULATE (COUNT (TableBGrouped [AccountID]); TableBGrouped [Count] > 2) Add. 11-16-2018 09:27 AM. I've tried different things but it seems impossible to. Or they use NEXTDAY to retrieve the day after a given date. If you would like to learn more about RELATED, do check out my blog post on Power BI DAX’s RELATED vs RELATEDTABLE Function. Welcome to the November 2023 update. In DAX, generally Row Context doesn't work with the relationships. It includes two different types of modeling for analysis services: Tabular and Multi Dimensional. In today's video, we will go through two functions in DAX, related and relatedtable. Rounds a number to the specified number of decimals and returns the result as text. Column = LOOKUPVALUE (TABLE1 [NAME], TABLE1 [ID], RELATED (TABLE2 [ID])) This worked fine, because I had an active relationship between Table1 & Table2. The RELATEDTABLE function assigns values from the associated table. There are plenty of ways to do this. Now this active relationship needs to be an inactive relationship, and the related function can't find TABLE2 anymore. I have created the measure below to count equipment events over time. RELATED: Returns a related value from another table. You are ready to read and query the tables using your favorite data tools and APIs. 0. Filters flow from the “one” side of the relationship to the “many” side. With the help of an example i have demonstrated how to use related function when. Multiple filters in DAX with OR Keyword. Let’s get started-. 1. Syntax DAX RELATED(<column>) Parameters Return value A single value that is related to the current row. Working Hours = IF ('Main' [Location]= RELATED (Indianlocations [Location]),9,IF ('Main' [Location] = RELATED (Otherlocations [Location]),8,0)) Pragati11. You can use TREATAS to apply the filter context of the product table to the Sales table by using the. This article describes different techniques to retrieve multiple values from a lookup table in DAX, improving code readability and. The result table includes only values that exist in the ColumnName column. VAR max_val = MAX (MyTable (column_name)) . DAX ย่อมาจาก Data Analysis Expression โดย DAX คือชุดของ Functions, Operations และ Constants เพื่อการคำนวณใน Data Model ที่จะนำไปใช้กับ Power BI Desktop, Power. Question 36 :- What is the difference between Related and RelatedTable ? Question 37 :- What is the use of DateAdd and ParallelismPeriod Functions?Row context does not propagate in either direction unless you specifically enable it using the RELATED or RELATEDTABLE functions. If the tables are related, this is very simple, you can see the below-given suggestion: Number of Table2 rows = COUNTROWS(RELATEDTABLE(Table2)) Then you can add a Calculated Column to Table1 which counts the times each item appears in Table2: Number of Table 2 rows: COUNTROWS(RELATEDTABALE(Table2))by PowerBIDocs. What is the best way to vertically combine two large tables of the same structure. In powerBi, a column is created with below formula, and it is working good. relatedtable関数は、指定されたリレーションシップテーブルにおいて、関連する行を全て返します。. RELATED [WIP] RELATEDTABLE. (18:27) RELATED VS RELATEDTABLE, DATEADD & PARALLELPERIOD Functions in DAX. My case is that I don't want to assign the primary key to Table 1 and assign the foreign key to Table 2. You can visit the rest of our. These functions are used to access data from related. In the products table we could we could set up a measure to calculate the following. This is a short video on how to use related and relatedtable function in PBI. Excel offers a simple function to compute the number of working days between two dates: NETWORKDAYS. IF (max_val. The returned table is a sub. The three set functions available in DAX are: UNION, INTERSECT, and EXCEPT. This article describes how to create a measure displaying the name or value of an element that has a specific ranking, with different option for managing ties. DAX — Chapter 18. I have two related tables, and the result of the lower right pivot should match the pivot to its left. In this article we describe why and when to use these two functions. Today, let’s talk about the RELATED and RELATEDTABLE functions. Many DAX newbies use LASTDATE to search for the last date in a time period. Power BI DAX’s RELATED vs RELATEDTABLE Function Let’s talk about the RELATED and RELATEDTABLE functions. TREATAS is the clear choice when you implement a virtual relationship, but you can also see that with a large dimension the advantage of a physical relationship is huge. In a general, the DAX CONCATENATEX function returns a text string by concatenating the results of an expression evaluated for each row in a table. ENTERPRISE . This function below works in that it returns the values that I expect from creating a new column in ‘ResourceTimePhasedDataSet’ called ‘Demand’ that is calculated from a relationship to a 1 to many table named ‘Assignments’ by filtering on [AssignmentStartDate] (from ‘Assignments’) being <= [TimeByD. There. However, if you are sure that the tables already have a relationship and the provided column name is correct but the RELATED function still is not working as expected and the IntelliSense doesn't list any suggested columns, so you maybe encounter this behavior. . With a lot of data in the file, it surely makes a major difference in the performance. . DAX Puzzle: RELATED in a Query. CONCATENATEX () As with other DAX functions (SUM, COUNT, AVERAGE,…. 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. This means that there is no active or inactive relationship between, in this case, the Date. Create table. These functions are used to find the highest value in a column or a table. 16. If you create two calculated columns that actually reference each other, then you are generating a circular dependency: 1. Estas funciones te permiten acceder a un valor o al resultado del calculo de varios valores que se encuentran en otra tabla relacionada. The less complex the model is, the better the. 2. -- DISTINCT does not return the blank row caused by an invalid relationship. RELATED and its companion function RELATEDTABLE, are two common DAX functions that are required when using a row context with relationships. USERELATIONSHIP: Allows a calculation to use an inactive relationship. We use these functions when we need to communicate. DAX SQL. 1 ACCEPTED SOLUTION. Anyone? ExampleI want to return a value based on a measure from a related table. Step-3: If you want to see Region wise counts, To achieve this, place a slicer on the report canvas and then drag the “Region” column onto it. RELATEDTABLE: Returns the. The Related function in DAX can be used to fetch a value from a field of another table. Value = Sales [QTY] * LOOKUPVALUE (Products. Related Functions in DAX The beginner level attendees of our Power BI training often find it difficult to fetch values across the tables in a data model. Part seven of an eight-part series of blogs. So, I don't think it is used correctly here. Hi. VAR max_val = MAX (MyTable (column_name)) . A filter context is a set of filters over the rows of the data model. '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. This book covers Tabular modeling, which uses tables and relationships with a fast in-memory engine to provide state of the. However, there are some built in DAX functions which can take advantage of existing relati. What DAX formula should i use in order to bring to dCadastroProdutos the ULTIMA. This daily values table includes as well as values from an index that is not a stock. From this blog, you got some idea about 3 important filter functions (LOOKUPVALUE, SELECTEDVALUE, RELATED. Nevertheless, the whole DAX semantic is based on the theoretical concept of expanded. Transactions [period_year] = MAX ( Transactions [period_year] ) Now i have created a seperate Date table and seems like I cannot have the same expression but using the fields from the new data table:Data Analysis Expressions (DAX) Reference. If I answered your question, please mark my post as solution, this will also help others. One contains customer information and the other contains subscription details. Converts a value to text according to the specified format. ATTR are random attributes of the transaction. 0. RELATED: Gets the value of a relationship from “one” side. g. GLYCERIA Co-Founder. Sep 14, 2020. RELATED: Returns a related value from another table. Jun 11, 2022. 7. Relationship is as follows. Most errors involving context transition are due to the developer forgetting to take the context. C. The column must be named using standard DAX syntax, usually, fully qualified. 🚀 Understanding when to use RELATED() or RELATEDTABLE() can be a. The RELATED DAX function can't be used to retrieve the. Power BI DAX’s RELATED vs RELATEDTABLE Function Let’s talk about the RELATED and RELATEDTABLE functions. Product current cost (test) = SUMX ( RELATEDTABLE ('Store Lookup'), 'Product Lookup' [current_cost] ) We need to specify the table if using SUMX. . -- VALUES does the same. . . Native columns are the ones originally present in the table. A 100 RELATED and its companion function RELATEDTABLE, are two common DAX functions that are required when using a row context with relationships. 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. The syntax of these DAX functions is simple and easy to understand. Right click on Dataset and click to New measure, then write below DAX. LookupFunction = LOOKUPVALUE ( SearchTable [Category], SearchTable [Product], ThisTable [Product] )Second, both tables are related with one to Many relationship, for document Number and Revision from document table = Document Number & Revision table from WF table, it may have one or more date value (Date due, Date finished) from WF table for each document Number and Revision, so just try this formula logic as mwegener:02-11-2019 01:09 AM. By default filter contexts should only propagate in the 1-to-many direction. @Anonymous, Just pick columns between mutiple tables may cause some issue or mistabke. ##SQLSatMadrid Escenario: Control de errores. I want a meassure that checks a column in the "many" table to see if a value exists for the row on the "one" side. Table "One" a b c Table "Many" a : 1 a : 2. So, it looks up the values in the One-Side and it populates the Many-Side. . Value = Sales [QTY] * LOOKUPVALUE (Products [PRICE],Products [ITEMS. See Attached Picture. Nesse vídeo iremos entender o que é e como funcionam a função RELATEDTABLE da DAX no Power BI. Read related article. Could you please advice on how to do so, most of the examples on web are using. To give an example, first with no filtering (displays 3 correctly): When filtering on Staff=B, though, it still displays 3 even though it should be 2:I'm struggling with DAX, and want to complete the simple task of counting the number of games hosted by a given player (one table) based on the distinct number of rows in another table (game_instance). 👇🏽Clic Para Mas 👇?. . . The Power BI TREATAS function applies a result of a table expression as filters to columns from an unrelated table. 并且上述表达式也没有任何意义，不知道它到底想要从订. 10-31-2017 10:30 PM. Hola @DevadathanK, EN El operador en Power BI devuelve un valor VERDADERO / FALSO. Chapter 20: Power BI DAX RelatedTable Function: Get the subtable related to the current row Chapter 21: UseRelationship or Role-Playing Dimension; Dealing with Inactive Relationships in Power BI Chapter 22: DAX CrossFilter Function in Power BI: Write the Formula both-directional, but keep the relationship single-directionalRelated. microsoft. So, if they are similar, which one should be used in which. LINESTX DAX Function (Statistical) LINESTX. Also, if you have a complex model, it is recommended to do as many modelling at the Datasource level. -- and COUNTROWS. DAX 101: Using RELATED and RELATEDTABLE in DAX. Related columns are all the columns of related tables, added to the original table through table expansion. USERELATIONSHIP () is a functionality that is available with CALCULATE () used to activate a relationship during the evaluation of an expression, as we know, a data model may. 144 Share 10K views 1 year ago #dax #powerpivot #powerbi RELATED: Returns a related value from another table. Suscríbete al Aprendizaje: Y RELATEDTABLE son dos funciones DAX relacionales que permiten movernos dentro de las tablas apro. Lets understand the difference between RELATEDTABLE and RELATED DAX functions. However, unlike the other function, the RELATEDTABLE returns a table as the output. DNA . -- though the second expression returns an empty table. It gives you the complete toolkit! 🛠️💼 Mastering these DAX functions will elevate your data analysis game in Power BI. A user can be the owner of an opportunity regardless of the account it belongs to. Can be accessed using DAX functions like RELATED, RELATEDTABLE, or USERELATIONSHIP. Fonctions Power BI RELATED et RELATEDTABLE en DAX en 5 minutes !🔥 Apprends à utiliser ces deux fonctions à travers deux exemples concrets A la manière d'un. Gestion des dates. If you have worked with any databases or BI tools, you must have created relationships between tables to form a snowflake schema or star schema. Gestion des dates. In general, using the example described in this article, the DAX LOOKUPVALUE function can be interpreted as follows. The above picture shows physical relationships: Visible links between tables (typically 1:* cardinality). If the filter context is empty, a DAX expression can iterate all the rows of the tables in a data model. The following table summarizes the variations of ALL that are provided in. Conclusion. RELATEDTABLE 📈 1️⃣ RELATED Function: RELATED establishes a connection between two tables through a single-column relationship… DAX関数のRELATED()とRELATEDTABLE()関数の違いと使い方を説明しました。参考にした書籍は以下です。. So the result should be. How to write queries in DAX to interrogate SSAS tabular models. If you have any questions related to this project, please feel free to post your comments. Aug 30, 2022. EXCEPT removes the rows of the second argument from the first one. If you would like to learn more about RELATED, do check out my blog post on Power BI DAX’s RELATED vs RELATEDTABLE Function. That makes the RELATEDTABLE function a tabular function. -- GENERATE is similar to CROSS APPLY in SQL. DAX: StockV (related) = SUMX (Products ,Products [Unit Price] * RELATED (‘Stock Levels’ [QTY])) This is a very similar function to what we just did, but in this situation, I used the SUMX function for the. If you can understand this function, you'll see its many applications across reports and dashboards that you might be creating inside of Power BI desktop. Here is the CONCATENATEX formula we would use to achieve this custom column: Orders = CONCATENATEX (RELATEDTABLE (Orders),"Order Number: "&Orders [Order Number]&", Value: $"&Orders [Amount]," and ",Orders [Amount],DESC) Here is the result: The last two parameters specify that the expression should be ordered by the. In this example, using CONCATENATEX helps identify – out of a list of countries where a company does business – the top performing country with its relative sales volume. -- GENERATEALL is similar to OUTER APPLY in SQL. This article describes how to create a virtual relationship in DAX using the TREATAS function, which is more efficient than approaches based on INTERSECT or FILTER. But from the above report, you can observe, the same product count value is repeated for each year. Using RELATED function in DAX with USERELATIONSHIP. 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. The complete pattern also includes measures that improve the visualization of ragged hierarchies in Power Pivot. 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. . RELATED, RELATEDTABLE – DAX Guide. Also, the relationship between Date and ResellerSales is one to many, it wouldn't be possible to use RELATED, but RELATEDTABLE and an aggregator would be required, like for instance. If the two tables are related, try this: Column = CALCULATE ( DISTINCTCOUNT ( DA_FACT_DMS[Well_Name] ) ) Best regards. WEEK1 and WEEK2 are the fiscal weeks of DATE1 and DATE2 respectively. I still do not understand why we do not need to use RELATE or RELATEDTABLE in here even both the table has active relationship. Line Margin = Sales [Line Amount] - Sales [Discount Pct] Discount PCt = DIVIDE ( Sales [Line Margin], Sales [Line Amount] ) Copy Conventions # 1. USERELATIONSHIP. Using RELATED function in DAX with USERELATIONSHIP. You can include columns in other related tables, if one or more many-to-one relationships exist to reach the referenced tables. This is an in-depth video lecture of the Related distinct count pattern. RELATED() RELATED() follows existing many-to. You specify the column that contains the data that you want, and the function follows an existing many-to-one relationship to fetch the value from the specified column in the related table. -- It provides most querying features in a single function: -- First set of arguments are the groupby columns. DAX Many-to-Many Power Pivot Tabular. Hi Guys, I need to create a calculated column with userelatioship. Like JK, I have two related tables. Try and reserve DAX for calculations and keep the use of it to make calculated columns to a minimum of possible. In this video, we will learn about the DAX related function how to use it and when to use it. Note: You must create a relationship to can use the RELATED DAX function. Keterangan. DAX CONCATENATEX Function. I need to report the transaction amounts by the 'week of' for. In your example, table 1 expanded table contains table 2 but not vice-versa. more. . This simple formula includes the definition of two variables: 1. I am talking about RELATED and LOOKUPVALUE. 1. It is different from the DAX CONCATENATE function in many ways including that it is a table function (DAX functions that end with "X" e. You can see in above screen shot, it retrieves all records from the left table along with the matching records from the right table. The data result from expressions evaluated for each row in a table. This creates a circular issue when trying to relate the tables, as demonstrated below. RELATED vs LOOKUPVALUE – which one to use? (DAX – Power Pivot, Power BI) There are two functions in DAX with similar, and sometimes replaceable, use. In simple terms it is used on the one-side of a relationship to access the related rows in the many-side. 2. Sales = SUMX(RELATEDTABLE(SalesItems), SalesItems[Amount]) I want to add a FILTER: SalesItems[Status] = "posted" so that only the amounts that have a status of posted are summed. Even though this function is commonly used for dates, it can be applied to a column of any data type. When filter expressions are provided, the CALCULATETABLE function modifies the filter. Choose the common column between these two tables as “Product. Add a DAX calculated column to the SALES REPORT table: Value = Sales [QTY] * RELATED (Products [PRICE]) You can use LOOKUPVALUE to get the result from the other table if you don't have a relationship defined between the tables. Running the above formula gives you the following error: Function RELATED expects a fully qualified column reference as its argument. Since the "search_value" parameter of the function is first evaluated before the "search_columnName" and the "result_columnName" parameters, you can interpret the example like "lookup the "Category" value or column in Dataset 2 from Dataset 3, and where it matches do return. For example, a simple calculated. Can be active or inactive. 🔸 Conheça o Curso Express de Power BI e alcance o nível intermediário em poucos dias:. DAX RELATED () with MANY-TO-MANY RELATIONSHIP. If two tables are linked by more than one relationship, you can decide which relationship to activate by using USERELATIONSHIP. I hope you can help me on this 1. When I add the Product Lookup table then the DAX will be the same as mine. USERELATIONSHIP: Uses a specific inactive Power BI model relationships by default. In my next blog, we will learn more about DAX. power bi related & relatedtable function will help you to get different column from another table. The difference between the two functions is related to the input type and the output type. DAX Query with multiple filters in powerbi. . RELATEDTABLE() RELATED() and RELATEDTABLE() are the two functions used to traverse one-to-many relationship in. 12. And it works exactly the same! Hence, we can use USERELATIONSHIP instead of CROSSFILTER when there is huge data and complicated relationships. Physical relationships are manually created and visible in your data model. The RELATED function requires that a relationship exists between the current table and the table with related information. power bi related & relatedtable function will help you to get different column from another table. This works fine and the date is displayed from the "deadline" of the task: I do however have a secondary date. Continuing with the “Jan-2021” example, if we filtered the “ Sales ” table. The new DAX available in Excel 2016 and the data model in Power BI and Analysis Services 2016 offer tools to manage many-to-many relationships in a more efficient way than previous version, as described. You can visit the rest of our blog. Qual função tem a melhor performance. Here, in this video, I have explained, how can we use RELATED & RELATEDTABLE DAX functions to take advantage of existing relationships in the data. Since there are many tables that have relationship to the People table, only ONE relationship is active and the rest are inactive. So, if they are similar, which one should be used in which. Among these are books such as Power BI DAX Simplified, Pro Power BI Architecture, Power BI from Rookie to Rock Star, Power Query books series, Row-Level Security in Power BI and etc. 1 Answer. We need to connect to the Power BI file with the help of Query Plan and the Server Timings. RELATEDTABLE: Retrieve a table of rows from "many" side of a relationship. The RELATEDTABLE function assigns values from the associated table. e. For demonstration purposes we use the. A table of values. This puzzle is a single and simple question, but you have to find the exact answer. ฟังก์ชัน RELATED กําหนดให้ความสัมพันธ์เกิดขึ้นระหว่างตารางปัจจุบันกับตารางที่มีข้อมูลที่เกี่ยวข้อง คุณระบุคอลัมน์ที่มี. RELATED and its companion function RELATEDTABLE, are two common DAX functions that are required when using a row context with relationships. The RELATEDTABLE function performs a context transition from row context(s) to a filter context, and evaluates the expression in the resulting filter context. You will be able to use RELATED function directly only if it is a "one to one relationship". This function is a shortcut for CALCULATETABLE function with no logical expression. The RELATEDTABLE function returns a table that is related to the current. The Data Analysis Expressions (DAX) language is a formula language for Power Pivot, Power BI Desktop, and Tabular modeling in SQL Server Analysis Services (SSAS), which allows users to define custom calculations in PowerPivot tables (calculated columns) and in Excel PivotTables (measures). The RELATED function requires that a relationship exists between the current table and the table with related information. RELATED: Returns a related value from another table. ) would suffice (if used in a measure). I have 3 tables, main project, with project number, name, date and so on, Expenses table, with expenses type, value, date, etc and Time table, with tasks description, dates, values, etc. The calculation can be written in several different ways, each one with. Share. DAX. DAX Optimization - CALCULATE, COUNTROWS, FILTER, RELATEDTABLE. You can use simple filters or you can use more advanced. RELATED or RELATEDTABLE? 08-10-2020 02:56 AM. RELATED and LOOKUPVALUE are working similarly to LOOKUP function in Excel. In this post, I dive into creating virtual relationships using one of the most advanced DAX functions in Power BI called TREATAS. The MAX, MAXA, and MAXX functions are some of the most commonly used DAX functions in Power BI. These functions are used to access data from related tables in your data model. The Filter Context is a set of active rows in all the tables of the data model that are considered while evaluating a DAX expression. Step 2: Now Create Measure to find maximum sale value from sale column. MAXX. Conclusion. What CALCULATE does is it returns what is deemed a scalar value. Best way to connect tables (but not always possible). It is used to establish a relationship between tables based on a common column, and then retrieve related data from one table to another. This process would repeat for each month-year in the “ Calendar ” table. The subscription table has zero or more entries for each customer. Posted on June 8, 2021 Get a field’s value from another table in Power BI using DAX related function Sometimes, in Power BI, you need to access a field’s value from another. The argument specifies a column reference, and the function follows a chain of one or more many-to-one relationships to fetch the value from the specified column in the related table. Úvodem do relací. -- If the second argument returns an empty table, GENERATE skips the row. Before elaborating further on the row context, it is important to understand why the row context is so relevant. UPDATE 2022-02-11 : The article has been updated using DAX. Hosted Games = CALCULATE (DISTINCTCOUNT (game_instance [id]), FILTER (game_instance, game_instance [owner_id] = [id]))Step-1: Go to the Modeling tab > click on create a new table icon. See the example below for a thorough explanation. Ver datos. If this post helps, then please consider Accept it as the. ##SQLSatMadrid DAX Agregar con RELATEDTABLE() RELATEDTABLE() Sigue la relacin 1:M y devuelve todas las filas que se relacionan con la fila actual. Can. To learn more about DAX visit : aka. Step 1: Sample Dataset with table visual as below. This week, let’s discuss the difference between the RELATED and LOOKUPVALUE functions. DO for the sample queries and removing the outdated part. power bi related & relatedtable function will help you to get different column from another table. Now, return and choose “ New column ” for “ Product_Table ” and open the RELATED function. Intente modificar su DAX de. CÓDIGO UTILIZADO NO VÍDEO*****. RANKX. [Build ID] is from Build WI table, and the aggregation operation selects the maximum. You can think of the row context as the “current row” in a table. These functions are used to. Dec 13, 2021. The result of a JOIN does not depends on the presence of a relationship in the data model. This is an in-depth video lecture of the Related distinct count pattern. -- DISTINCT retrieves the distinct values of a column. activedays = COUNTAX (RELATEDTABLE (ActivesInactiveData),ActivesInactiveData [Surface Date]) However, I want to add a filter some thing like. ) would suffice (if used in a measure). Try modifying your DAX as follows: Working Hours = IF (. To obtain a browsable hierarchy in the data model, you have to naturalize a parent-child hierarchy. The returned table is a sub-table of the given table for all records that match the key in the current row of the current table. Related and RelatedTable functions differ mainly in the side of the relationship they go from in a data model. It cannot be an expression. 02-07-2019 04:06 AM. I'm fairly New to Power pivot and DAX-formula and I just can't seem to find a solution. If you are not sure if Direct Query vs Import is causing an issue, try switching BOTH queries to Import and try it. [予実比較] = 売上明細[販売単価] - related(商品[定価]) related関数はリレーションシップの（1対多）関係のうち、「多」側のテーブルで行コンテキストが評価される場合に機能します。「多」側テーブルから、関係テーブルを参照できます。 Conclusion. If the REMOVEFILTERS function is supported by your tool, it's better to use it to remove filters. If you simply want to find the maximum value of a column in a table on many-side of the relationship (related table) for each row in a table on the one side of the relationship then simple. There is some useful info in the Definity Guide to DAX about using RELATEDTABLE on the one side of a one to many relationships. BigTable_DAX = UNION ( 'Table1', 'Table2' ) I have a feeling that M way loads the tables. But while RELATED takes values from the "short" table to the "long" one (from the "number one". It gives you the complete toolkit! 🛠️💼 Mastering these DAX functions will elevate your data analysis game in Power BI. If you simply want to find the maximum value of a column in a table on many-side of the relationship (related table) for each row in a table on the one side of the relationship then simple. While using this DAX function it is important to understand the following items: For this function to work it is important to ensure that there is a relationship created between the current table and the table with the related information you are. 1. As the link says, RELATED is more efficient. 🦸♂️ 2️⃣ RELATEDTABLE() Function: Now, meet the data magician, RELATEDTABLE(). UPDATE 2023-03-17 : Fixed an incorrect description before example #11. We talked about LOOKUPVALUE a while ago; this is a simple function which returns the. As you can see above, we have a table name with all the columns of the related table. Remarks.