I need help getting a ROLL UP SUB TOTALS for a template value

DAX DAX Calculations
3

@BenBen2,

With regard to your second question, if you’re using @Melissa’s awesome Extended Date Table, this is a snap. You can just create a one column table of working dates via:

Working Dates = 
CALCULATETABLE(
    VALUES( Dates[Date] ),
    FILTER(
        Dates,
        Dates[IsWorkingDay] = TRUE()
    )
)
  • Brian
1 Like