Forum Discussion
Lookupvalue will not return time value
Hi Kristen,
You can use Query editor as well to solve this type of problem.
Just few mouse clicks and you are done. Follow the screenshots for exact solution.
Merge Table 2 and Table 1 as shown in the ScreenshotExpand the new column and select Event Type & Time of Event CheckboxesChange the data Type of the last column to Time and Rename both the columnsTime of the Event Column with new Data TypePivot the Column. Select the options shown in the screenshotAll done. TA....DA........
Anonymous You need to have unique combinations of [JoinKey] and [Event Type]
To test this create a COLUMN In Table 1 Create
Column = Table1[JoinKey]&" - "&Table1[Event Type]
Then create this MEASURE
Transactions = COUNTROWS(Table1)
Then create a Visualization Table with the Column and Transactions.
If you see anything other than 1 for each column - that will be what's causing the problem!
Basically the function will have more than 1 possible answer that meets your criteria.
Hope this helps and makes sense! :smileyhappy:
You can use the Visual Level Filters to => show Transactions more than 1 so you can identify the problem faster.
EDIT: Just to clarify - my post was merely answering your question about the error message you get with the LOOKUPVALUE.
I would personally also use with the Query Editor to shape your original dataset better.
Thank you very much for the prompt reponse!