Calculate: Compare counts of Current vs Prior Week

DAX DAX Calculations
1

Objective is to determine the “prior week” history-to-date count, so that the WoW count (% growth) can then be calculated for any given Week Ending, using offsets, etc. Thanks in advance. PBIX file of data model available here: Data Model with Mockup _ weekly delta in count.pbix (3.0 MB)

image

2

Hi @mdalton2100,

Give this a go.

Developers Active (? prior week history to-date) v2 = 
VAR cWeekOffset = MAX( Dates_enhanced[WeekOffset] )
RETURN
IF( cWeekOffset <=0,
    CALCULATE( [Developers Active (solved)],
        FILTER( ALLSELECTED('Dates_enhanced'),
            Dates_enhanced[WeekOffset] <= cWeekOffset -1
        )
    )
)

I hope this is helpful.

2 Likes
3

Works beautifully, Melissa. Thanks.