Forum Discussion
gambleave
4 years agoHelper II
Linking a table with mixed data fields
May I please have advice on how to incorporate a table such as the one below into a typical data model? Can it be achieved with measures only, or does the table itself need to be modifed? The tab...
speedramps
4 years agoSuper User
Please can you provide example data as table not screen short so we can import it and build an solution.
Dont share private data. Delete the post it you have share private data or you manager and clients may complain.
- gambleave4 years agoHelper II
Yes of course, doesn't seem possible to upload files here... I've posted sample data here.
Basically, I want to consolidate multiple rows concerning the same consultant and account and add columns naming the account managers indicating Yes/No to introductions. If there are both Yes and No instances of feedback for the same consultant vs. the same account, the Yes would override the No.
I'm a relative newbie...would appreciate advice on how this can be achieved!