Hi People,
Im sorry for asking this as Im sure its a ridiculously simple fix, Ive tried "SELECT" and [_THISROW] and multiple other variations over the last couple of hours.
This is referencing my "Timesheet" table where I have a column [Project} which is the same as [Project Number] in the "Projects" table.
So I just want to display (Projects[Client]) and (Projects[Project]) where (Projects[Project Number]) is the same as [Project]
<<START:Projects[Project Number]>>
<<[Project Number].[Client]>>
<<[Project Number].[Project]>>
<<END>>
Any help please...๐
I should mention, that the above expression pulls all values from Projects[Client] and Projects[Project]
Maybe this?
<<START: FILTER( Projects , [Project Number] = [_THISROW].[Project] )>>
<<[Project]>>
<<[Client]>>
<<END>>
Thankyou so much!! ๐
User | Count |
---|---|
40 | |
32 | |
30 | |
16 | |
16 |