Swati Vishwanathan
New Member
Hello
I want to have a list of dates which I can use to count cases opened and closed in a particular period. I want to do this in a pivot table so I dont want to use my opened date or closed date as dimension. I want to use an independent list of dates for this.
When I try to create a calendar table in power pivot so I can link it to my case data, I keep getting an error that it is not formatted as date or contains duplicate values.
I dont see any duplicate values...all are unique dates and it is also formatted as date...
Please can anyone assist me
Regards
Swati
I want to have a list of dates which I can use to count cases opened and closed in a particular period. I want to do this in a pivot table so I dont want to use my opened date or closed date as dimension. I want to use an independent list of dates for this.
When I try to create a calendar table in power pivot so I can link it to my case data, I keep getting an error that it is not formatted as date or contains duplicate values.
I dont see any duplicate values...all are unique dates and it is also formatted as date...
Please can anyone assist me
Regards
Swati