Cumulative Pay Period Calculation

[Greg]

Hi @talk2gwhite.

The benefits of the forum … I was just about to post almost exactly the same thing, albeit without the extra code to generate your Monday-after-pay-period-end-date Report Date … @Melissa beat me to it

Just for completeness, here’s what I wrote:

A small modification should get you close to where you’re going. You can use the Cumulative Total DAX pattern

Cumulative Total

Use the Cumulative Total pattern to change the context from the particular selected date to all dates up to and including the current date. Cumulative Total = // DAX PATTERN NAME: Cumulative Total // NOTES: Use CALCULATE to change the context from the particular selected date to all dates up to and including the current date` // TIP: Select the text to change, then use CRTL + SHIFT + L to rename all occurrences at once // TIP: Use CRTL + mouse scroll wheel to zoom the text size CALCULATE( …

to create the measure of interest, something like:

Cumulative EOD = 
CALCULATE( [Pay Period Count of EOD],
    FILTER( ALL( Dates ),
        Dates[Date] <= MAX( Dates[Date] ) ) )

Then you can change the line chart to a combo chart, add the new cumulative measure to the line series, and turn on data values.

Hope this helps.
Greg
eDNA Forum - Cumulative Pay Periods V3.pbix (201.7 KB)