Forum Discussion
combining data from multiple sources periodically - date hierarchy no longer works
Anonymous as soon as you have a relationship on date column that hierarchy is not there anymore because internal date tables don't exist anymore, having said that, you can create your own hierarchy in date table and use that and this is the right way to do the model, in other words, you are on right track.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
Anonymous check the data type of your date column maybe once you append the table the data type of that column is not date anymore and that's why you are seeing the hierarchy.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
Hello
I have checked and all my dates in all tables are formatted as dates.