If the fact table updates daily, for example, with 10 customers making transactions every day and adding 10 rows to the dataset, will the date table be updated to cover the entire date range? If not, what could be a possible approach to creating a dynamic date table?
Take min and max of fact table date column as the start and end date respectively while writing the logic for the date table. This way it will automatically update the dates in the date table as well.
Clean Explanation. Thanks for this.. How can we add the End Of Month to this table?
Add this to the logic for end of month dates:
Eomonth([Date], 0)
@@bitricks Thanks 👍
Its wonderful job... Thank you so much bro
Thanks bro, I was looking for it
If the fact table updates daily, for example, with 10 customers making transactions every day and adding 10 rows to the dataset, will the date table be updated to cover the entire date range? If not, what could be a possible approach to creating a dynamic date table?
Take min and max of fact table date column as the start and end date respectively while writing the logic for the date table. This way it will automatically update the dates in the date table as well.
Thank you very much for this great video. Keep doing a good one. GBU.
Hi. I am trying to make date table but it's not happening. Need your help. How can I contact you?
Very nice
Please let me know