Forum Discussion
Pivot fields to filter visual
hi this is not the most elegant solution, i would probably try and merge them in power query but since i dont have access to the source file what i have done is created a new table called offer accepted, and filtered that only on accepted offers. I then join that back to link main info on the destination id = source id (look in the relationship view how i have joined them) and then created a measure that does that join with the conditions.
im sure there is a better way to do this but it works.
Hi vanessafvg ,
Please find my comments on your questions:
a) how do you know the candidate that an offer has been given to, what identifying information helps you to join these 2 pieces of data together is it an id? if so which id. Yes!, the table that contains the link information is 'Link Main Info' under the column 'LINKNAME' with the category OfferedBy-Offer for candidate and there's two ID's the Source ID and Destination ID in this case I think the ID of the offer should be under the Destination ID column.
b) which table are you referrig to from what i can see you are using the link main info. Yes the table used is Link Main Info.
Any further questions please let me know.
Best,
hi unfortunately i am about to go away so i dont have time to assist maybe amitchandak wants to step in and help.
otherwise i can help next week.
Hi vanessafvg ,
Thank you for your help.
amitchandak is there any additional information that I can share to you?.
Thanks in advance.
Best,