Power Bi DAX - Return most recently modified type name for each ID number
0 I have two columns in one table, "ID Number" and "Modified On Date" and one column in another table "Type". I want to return the most recent Type for each ID number. Using a DAX measure in Power BI I have the following: LOOKUPVALUE('Table 2'[Type],'Table 2'[Type],MAX('Table 1'[Modified On Date])) This formula is wrong as I am comparing two different data types (type text with type date) however it shows what I am trying to achieve. The steps are: 1) Bring back the most recent modified on date for each ID number 2) Show the most recent Type for each ID. There is also the problem of having two tables, would I need to use the related() DAX function? excel powerbi dax share | improve this question asked Nov 13 '18 at 21:47 Pete Pete 76 1 1 14 This question is pretty similar. Does it help? – Alexis Olson Nov 13 '18 at 21:49 add a comment | 0 I ha