LNC = IF (HASONEVALUE (LANE [OBJ_TYPE] )= "LNP", "Y", "N") Any help Thanks PC ------------------------------ PANTRY COUPON https://exceltown.com/en/tutorials/power-bi/powerbi-com-and-power-bi-desktop/power-bi-data-sources/power-query-and-assigning-to-ranges-merging-of-tables-like-vlookup-with-last-argument-1-true/, Actual $ 50 Budget $ 100 and variance $ 50 and % variance is 50% working fine with below formula I'm trying to use the LOOKUPVALUE function to lookup values from Table 2 in Table 1. (adsbygoogle = window.adsbygoogle || []).push({}); (adsbygoogle = window.adsbygoogle || []).push({}); This might also be the case for the LOOKUPVALUE function. What is KPI and how to create in Power BI using Tabular Editor, How to Calculate the Cumulative Sum or Running Total in SQL Server, Hex Color Codes for Microsoft Power BI Themes, How to Find the Employees having same Salary By Department in SQL Server, How to remove a Carriage Return Line Feed (CRLF) from a String of Varchar Column in SQL Server, How to get the All Selected Values from a Slicer using DAX in Power BI, SSIS Package to Dynamically Create an Excel File with DateTime from SQL Server Table, How to check if a record exists otherwise Insert into a Table in SQL Server, How to Copy and Paste Excel Range as Picture in VBA, What is Full Cache, Partial Cache and No Cache of Lookup Transformaton in SSIS Package, How to Fix the SQL Arithmetic Overflow Error Converting Varchar to Data Type Numeric. Taking the exact same code, and referncing TruckOperatorName in Table2, gives the error. This article provides a theoretical foundation of what expanded tables are, along with fundamental concepts useful when reading DAX code. I have two data sources, one called Workday and one called Phishing Results. 50002 88034 01/04/2020 200, It depends. LOOKUPVALUE detects that the last argument is the default value if it does not belong to a pair - that is, there are no other arguments after it. This also happens when the expected result is a Boolean data type. Whenever you want to concatenate values from a column (either a real column from a real table or a virtual table) then ConcatenateX is a useful DAX function for it. However, it is often the case that these expressions are more dynamic, and this could generate a more expensive query plan that includes CallbackDataID requests to the storage engine. It cannot be an expression. Pulling values from one table to another - DAX Calculations Since your table 2 date duplicate record so i had to use the firstnonblank function. And I think the formula will work. See if any of these methods meet your requirement. (adsbygoogle = window.adsbygoogle || []).push({}); ADDCOLUMNS. actuals[CCC]; DAX Measure using Lookupvalue in Excel Pivot Table Where developers & technologists share private knowledge with coworkers, Reach developers & technologists worldwide. I have same unique id multiple times. budgets[Month]; SELECTCOLUMNS ( [[,