Calendar with recurring dates

[Anonymous]

Hi,

I have created a model with 4 different lookups along with a calendar from accident data.

There are repeated dates in the calendar table.

How to create a primary key so that it can be linked to the data table?

Awaiting any cues.

Thanks in advance.

[amitchandak · Accepted solution]

@Anonymous , Are you creating a calendar using the calendar command?

refer these blogs

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

Also, check how to deal with more than one date

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970