Forum Discussion

kastriot's avatar
kastriot
Frequent Visitor
7 years ago
Solved

Count based on two date columns

Hello,   I am trying to count values in [Staff ID] only if the month and year of [ExitDate] match the month and year of [ReportingDate] and I was hoping someone can help me.   Thank you  
Need Help
  • themistoklis's avatar
    themistoklis
    7 years ago

    kastriot

     

    First add a calculated column using this formula:

     

    Column = IF(YEAR('Table'[ReportingDate]) = YEAR('Table'[Exit Date]) && MONTH('Table'[ReportingDate]) = MONTH('Table'[Exit Date]),1,0)

    Then add this measure:

     

    Measure = CALCULATE(COUNT('Table'[Staff ID]), 'Table'[Column] = 1)

    Workspace on this link.

themistoklis's avatar
themistoklis
Icon for Community Champion rankCommunity Champion
7 years ago

kastriot

 

First add a calculated column using this formula:

 

Column = IF(YEAR('Table'[ReportingDate]) = YEAR('Table'[Exit Date]) && MONTH('Table'[ReportingDate]) = MONTH('Table'[Exit Date]),1,0)

Then add this measure:

 

Measure = CALCULATE(COUNT('Table'[Staff ID]), 'Table'[Column] = 1)

Workspace on this link.