Count if - Month and Year the same

[Anonymous]

Hello there,

I want to Count date rows, if the month and the year in the row are the same.

Is there a way to do this in DAX?

Beste regards

MSOMME

[Jos_Woolley · Accepted solution]

Hi,

MyMeasure =
SUMX (
    'TABLE A',
    0
        + ( EOMONTH ( 'TABLE A'[Created], 0 ) = EOMONTH ( 'TABLE A'[finished], 0 ) )
)

Regards

[Anonymous]

Thanks @Jos_Woolley ,

This seems to work so far, but unfortunatly this measures also counts the rows where The [Created] date and the [finished] date are empty. Is there a way to only count the rows, if they both have a value?

Best regards 

MSOMME

[Jos_Woolley]

Ok, then use this:

MyMeasure =
SUMX (
    'TABLE A',
    ( EOMONTH ( 'TABLE A'[Created], 0 ) = EOMONTH ( 'TABLE A'[finished], 0 ) )
        * ( 1 - ISBLANK ( 'TABLE A'[Created] ) )
)

Regards

[amitchandak]

@Anonymous , I am assuming you need a new column

New column =

var _eo = eomonth([Date], 0)

return

countx(filter(Table, eomonth([Date], 0)  =_eo), [date])

[Anonymous]

I really wasn't specific on this one. I have two dates in my table. A "created" date and a "finished" date.

I want to count those Rows, where both dates have the same Month and Year, so the EOMONTH function sure comes in handy here. 

I imagined something like this: COUNTROWS(TABLE A, IF(EOMONTH([Created],0)=EOMONTH([finished],0))

But I already know it isn't gonna work like that.

All help is very appreciated! @amitchandak