Forum Discussion
Best Solution for Month to Month Analysis without Causing Duplicate Data Errors.
Hi Lenihan,
What I was suggesting is that with the calculated table you can get all the unique CI Identifier across all your tables.
Then from tables you would create a relationship to the Calculated table.
What that then means is you could then use the Calcualted Table as a filter. And it will filter all the other tables?
Here is a blog post explaining how to create the Calculated Table - Connect any number of tables together via a common column
Hi GilbertQ
So similar to what I was suggesting then with the CI identifier merged with the reporting month? If I create that calculated column on each table then use that as the relationship. I guess this would mean any measures i create I would need to use the dax function userelationship for any formulas that require data from both tables?
Hi Lenihan,
What I was suggesting is that with the calculated table you can get all the unique CI Identifier across all your tables.
Then from tables you would create a relationship to the Calculated table.
What that then means is you could then use the Calcualted Table as a filter. And it will filter all the other tables?
Here is a blog post explaining how to create the Calculated Table - Connect any number of tables together via a common column
Hi guavaq,
That sounds possible to help. I'm going to start over from scratch because I've just tried so many different things, that I can no longer document what I've been doing! I'm going to start by doing this and see what happens. Thank you for the info.
Hi,
If I was also to add a master calendar table, how would that connect with the calculated table? Would it be separate from the dax expression so that it is not factored in for the calculated column ? Or, not even related to the calculated table, and I could still relate the date table to the other tables?
Hi Lenihan
When you create a calculated table, once it has been created it looks exactly the same as a table where you have imported your data. If you look closely you will see that the calculated table has got a slight blue colour to it.
From there you can then create any measures or create relationships back to your Master Calendar table.