should i remove duplicates on a date table

[akhaliq7]

When I create a date table should I remove duplicates?

[amitchandak · Accepted solution]

@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.

[akhaliq7]

thanks for the learning references

[akhaliq7]

I usually create my date tables in power query. ok thanks for your help