Forum Discussion
Post Prodigyshould i remove duplicates on a date table
When I create a date table should I remove duplicates?
akhaliq7 , How are creating the duplicate table?
Date table should not have any duplicate dates. In power query, you can use remove duplicate rows.
In Dax, You should create date table using calendar
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.
3 Replies
- amitchandak
Super User
akhaliq7 , How are creating the duplicate table?
Date table should not have any duplicate dates. In power query, you can use remove duplicate rows.
In Dax, You should create date table using calendar
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.
