Forum Discussion
Need Help on deciding DAX
You can however, make sure that the Merge operation doesn't duplicate your data (you really have to test for this). I would worry about this working as you would expect, given the presence of the Many To Many relationships (and me not knowing what is making up the relationship keys).
Thanks for your response, basically the company I am working for, uses an old 1980s AS400 system, and there is not much information available(for example no visual representation of the data model) and, I don't have much information about the primary key and foreign key, I have picked/choose tables based on the Access query(SQL View) which we use to pull information monthly for making manual sales report, and all the tables I have choose have one common key that is company no, but if can suggest, instead of making relationship, I should go with merging all the required tables? but I am not sure is it ok to do that.
SidraBsorry if i will be obvious, but be very carefull with fact tables that "can" have multiple rows of versions of your SKs. Taking out of the away the versioned rows, you probably could join summarized (to certain level) data of other fact tables.
By version i mean, you have a unique field key, that repeats itself in other rows, because of some context of your columns changed, thus creating the row that reflect that change for just that specific column, ending with several rows that have all the history changes for a unique key field.