Forum Discussion
Bci calendar not giving multiple date count
Hi Team,
I have started using a calendar format "Bci Calendar" and am not thouroughly understanding this . Please see the below issue and provide me a help to resolve the issue.
My Date field for this calendar is "Reported Date " and Measure Data is "Count of Incidents" as shown in screenshots. The highlighted ones in Blue color in calendar are the count for each day which should be 3 for 1st March, 1 for March 2nd ,2 for March3rd and 1 for March 4th . However, if you check its showing count as 1 for all 4 days . I am not doing distinct count as well .
But still receiving wrong count. Please check and let me know what shall i do in this case.
Hi Anonymous
I would suggest you add a Date column.Then use the column in the calendar.For further,please check the page1 and Hints in the sample report.Here is the article.
Column = DATEVALUE(Table1[Date])
Regards,
Cherie
3 Replies
v-cherch-msftMicrosoft Employee
Hi Anonymous
I would suggest you add a Date column.Then use the column in the calendar.For further,please check the page1 and Hints in the sample report.Here is the article.
Column = DATEVALUE(Table1[Date])
Regards,
Cherie