Forum Discussion

neelsonwheels's avatar
neelsonwheels
Regular Visitor
3 years ago
Solved

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

  • CALCULATE(COUNT('RefSubmit'[WeekNumber]), ALLEXCEPT('RefSubmit', 'RefSubmit'[WeekNumber]))

  • So for anyone that stumbles upon this post this is what gave me what I needed for now:

    CALCULATE(COUNTA(TableName[RefSubmit]))+0