Forum Discussion

Lenihan's avatar
Lenihan
Helper III
9 years ago
Solved

Best Solution for Month to Month Analysis without Causing Duplicate Data Errors.

Hi,  I'm trying to do a month to month analysis of data that does not have unique values on the key column. Now that I have to add another month on, I've come across a snag. I can't add the data bec...
Need Help
  • GilbertQ's avatar
    GilbertQ
    9 years ago

    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

GilbertQ's avatar
GilbertQ
Super User
9 years ago

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.

Lenihan's avatar
Lenihan
Helper III
9 years ago

Thank you for the help GilbertQ and MalS.  It appears using the calculated table has made things easier and I believe it is all working!