I would kindly ask for your support for an issue that is causing to me a severe headache!
Basically, i have a spreadsheet where i download the dates on which specific workflow events occur; the spreadsheet contains one row for each product made by one column for the unified product id and all the rest for workflow dates, like: Request Date; Dispute Date; Resolved Date; Invoice Date; Payment Date.
Each date is in the same format and what i see in excel and power pivot is something like 01/01/2014 00:00:00 obviously with all the minutes specified in it.
Following your guides I've manually created a Calendar Table, listing the range of dates from 01/01/2014 to 31/10/2015 one row/date for each day, than I've also added in PP the Month Number and Month Name to better represent the data.
The issue occurs when i create the relationship between, lets say, request date and the date on calendar; the system recognize the relationship but in the pivot table doesen't show the number of request for each month but just the total.
btw, to count the totals, i've just created a simple count function for each occurrence, like: TotaREquest:=COUNT(FP_Events[Request Date])
Do you have any idea of what I'm doing wrong?
Thanks
Antonio
Basically, i have a spreadsheet where i download the dates on which specific workflow events occur; the spreadsheet contains one row for each product made by one column for the unified product id and all the rest for workflow dates, like: Request Date; Dispute Date; Resolved Date; Invoice Date; Payment Date.
Each date is in the same format and what i see in excel and power pivot is something like 01/01/2014 00:00:00 obviously with all the minutes specified in it.
Following your guides I've manually created a Calendar Table, listing the range of dates from 01/01/2014 to 31/10/2015 one row/date for each day, than I've also added in PP the Month Number and Month Name to better represent the data.
The issue occurs when i create the relationship between, lets say, request date and the date on calendar; the system recognize the relationship but in the pivot table doesen't show the number of request for each month but just the total.
btw, to count the totals, i've just created a simple count function for each occurrence, like: TotaREquest:=COUNT(FP_Events[Request Date])
Do you have any idea of what I'm doing wrong?
Thanks
Antonio
