I need some advice regarding how to capture the latest week for which we have data in the facts table.
At the database level I can run a select statement to select the Max(transaction date) from facts table and get its associated Week from the Calendar Dimension table.
For eg: If the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.