Forum Discussion
Counting date submissions by week
I have a data table with a 'RefSubmit' column that denotes date of form submission. I have a seperate date table with all the things I need (e.g. Date, Year, WeekNumber, StartWeek, EndWeek). Based on Google I turned off time intelligence as I'm trying to make sure I I know how date/time is being calculated.
I'm trying to create a graph that displays the number of submissions in a week including weeks with no (zero) submissions. I think this is a multiple step process/calculation/filter, but I'm lost and not having much luck with searching. Any guidance would be greatly appreaciated.
So for anyone that stumbles upon this post this is what gave me what I needed for now:
CALCULATE(COUNTA(TableName[RefSubmit]))+0
2 Replies
- mickey64
Super User
CALCULATE(COUNT('RefSubmit'[WeekNumber]), ALLEXCEPT('RefSubmit', 'RefSubmit'[WeekNumber]))
- neelsonwheelsRegular Visitor
So for anyone that stumbles upon this post this is what gave me what I needed for now:
CALCULATE(COUNTA(TableName[RefSubmit]))+0