Forum Discussion

ValeriaBreve's avatar
ValeriaBreve
Post Partisan
1 year ago

Showing countrows with zero rows for a selected date range

Hello, I have a table called Date_Table_Action which has a 1->* relationship to table BBP_Actions on the date.   I need to display a table that has all the continous dates between the min date on ...
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi ValeriaBreve ,

Based on the description, try using the following DAX formula.

Count of Actions =
VAR _MinDate = MIN(BBP_Actions[ActionCompleteTargetDate])
VAR _MaxDate = MAX(BBP_Actions[ActionCompleteTargetDate])
VAR _DateRange = 
    FILTER(
        Date_Table_Action,
        Date_Table_Action[Date] >= _MinDate &&
        Date_Table_Action[Date] <= _MaxDate
    )
RETURN
SUMX(
    _DateRange,
    CALCULATE(
        COUNT(BBP_Actions[Id]),
        BBP_Actions[ActionCompleteTargetDate] = Date_Table_Action[Date]
    )
)

 

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.