multiple dates in model

[surajap123]

Hi Experts,

I have 3 tables in in model and all 3 tables are linked together by a single key. Table1 has subset ratio of only 1%, Table2 has 36% and Table3 has 99.92%.
Please note that dimensions are measures are in the same table.

Each table has its own Date field indicating when the transaction happened.

I wanted to create a striaght table in the UI with various multiple expressions(generally sum() & coun()) and Dimension is Date. Because the dates are different in each table, I am not sure how to acheive this??

Thanks!

[sunny_talwar · Accepted solution]

May be this thread might be useful

Canonical Date

[surajap123]

Hi Sunny,

Thanks for the link.

I will start working on it.
I assume multiple dates in a model very common. Do we always create canonical date for this situation or is there is eazy approach?

Also, if you know, could you give me a link table approach to solve the multiple dates issue.

[sunny_talwar]

Well I am not sure if there are other ways or not, but AFAIK this is the best possible way to handle multiple days. It might look messy at first, but once you are done with your data model, you would love it on the front end.