Hello,
I am using a linktorow() to display a detail view of a specific row.
The formula has to find the key column by making some changes to the current key.
LINKTOROW(SELECT(Jobs[Job ID],
[Job ID] = CONCATENATE(LEFT([_THISROW].[Job ID],LEN([_THISROW].[Job ID])-LEN([_THISROW].[Sub Job])),[Sub Job])),
"Jobs_Detail")
Job ID is the Key
There is a main job say job say 6 which is effectively the rownumber
There is also a sub job. So you can have job 6 with the same information but this one actually called 6-1 or 6-2 etc
This Overall job number referred to as [Job] is used in the formation of the Job ID by putting it at the end.
I would like to go to the newest sub job within this job. which in this case would be 6-2
To do this I want to grab the Key column, take off the last number of characters (determined by the length of its Sub job) then put on the MAX(Sub Job)
While trying to create this though It is now telling me "LEN function is used incorrectly"
The only thing I can see is that I am trying to use _thisrow. I tried removing it and it didnt change anything. Realistically I should need it yeah?
Can anyone else see whats wrong with my Len function?
LinkedIn
Twitter
