Forum Discussion
Transforming Scheme Data Into Logical Data
Could you please give some idea what is the end result for your solution should be ?
What is logical data in this context ?
N -
nickchobotar
In this particular example, we are looking at "organisation name" field, which is a lookup field. They all present themselfs with a similar data output.
organisation name is a re-named field. this will be the account lookup field native in dynamics online.
in terms of how we want to use that data, its for many reasons. being able to link opps, orders, activites etc.
You have to give us a little bit more information. Still not really sure what are you trying to get here.
..... "in terms of how we want to use that data, its for many reasons. being able to link opps, orders, activites etc."If I understood you correctly, you want to create a relationship between these tables : opps, orders, activites
I would suggest you to go over these articles:https://www.sqlsaturday.com/SessionDownload.aspx?suid=16462
http://www.sqlservercentral.com/articles/DAX/111311/
http://sqlblog.com/blogs/marco_russo/archive/2010/02/09/how-to-relate-tables-in-dax-without-using-relationships.aspxGood luck
N -