Count col A (date) Month Year matches col C (date) Month Year

[Anonymous]

Measure - Trying to Count the number of new starters each reporting period 

if month and year match both col A & col B  

[dm-p · Accepted solution]

Hi @Anonymous,

I've replicated your table and called it Report, so you might need to tailor the below according to how your table is named.

This can be solved in a number of ways - the approach I would use, to keep calculation logic simple would be:

1. Create a New Starter Column

Create a column in the table as follows:

New Starter = INT(
        MONTH(Report[Report Period]) = MONTH(Report[Entry Date])
    &&  YEAR(Report[Report Period]) = YEAR(Report[Entry Date])
)

This returns 1 if the employee's entry date matches your reporting period, and 0 if not. Here's how this looks in your table:

2. Create a # New Starters Measure

Now, add the following measure to your table:

# New Starters = SUM(Report[New Starter])

This will ensure that whatever your filter context is, the amounts should tally, e.g.:

Just Wanting a Measure?

Again, there's a few ways to handle this. Here's an example that combines the approach above and doesn't need the column (essentially putting the logic into a SUMX iterator):

# New Starters = 
    SUMX(
        Report,
        INT(
                MONTH(Report[Report Period]) = MONTH(Report[Entry Date])
            &&  YEAR(Report[Report Period]) = YEAR(Report[Entry Date])
        )
    )

As a heads-up for any future DAX questions, a lot more people frequent the DAX Commands and Tips forum and you may be able to get a faster and wider variety of responses.

I hope this solves your challenge. Good luck with implementing!

Daniel

---

If my post helps, then please consider accepting as a solution to help other forum members find the answer more quickly 🙂

[Anonymous]

thanks Daniel

The measure was exactly what i was after

appreciate your support