Forum Discussion

akoster3's avatar
akoster3
Frequent Visitor
3 years ago
Solved

Determining New Payroll Additions/Removals

The company that I work for has tasked me with making a table that will show people who are added/removed from our payroll each month.    So far, I've tried dividing it into two tables and us...
Need Help
akoster3's avatar
akoster3
Frequent Visitor
3 years ago

I went to the step in your tutorial 'Customer Retention Part 1' and tried my best to imitate what's in there. Since there is no sales data tied to this, this is what I have:


MTD =
DATESMTD('HeadCounts'[Year and Month Code])

LMTD =
DATESMTD(DATEADD('HeadCounts'[Year and Month Code],-1,MONTH))

New Payroll Additions =
sumx(
    VALUES('HeadCounts'[PERS_ID]),
    if(
        ISBLANK('HeadCounts'[LMTD]) && NOT(ISBLANK('HeadCounts'[MTD])),
        TRUE(),
        FALSE()
    )
)

New Payroll Removals =
sumx(
    VALUES('HeadCounts'[PERS_ID]),
    if(
        ISBLANK('HeadCounts'[MTD]) && NOT(ISBLANK('HeadCounts'[LMTD])),
        TRUE(),
        FALSE()
    )
)


I'm not sure exactly why, but it won't let me use these measures as filters on my visual.