Forum Discussion

Anonymous

Not applicable

5 years ago

Solved

filter month and year

Now dax count status date = 1/3/2021

If I want to check month and year only (month=3 and year =2021)

Please suggest me about edit DAX as below.

Count of Status Date = VAR __CurrentMeasure =

CALCULATE(

COUNTA('Update'[Status Date]),

'Update'[Status Date] IN { DATE(2021, 3, 1) }

)

RETURN

IF ( ISBLANK ( __CurrentMeasure ), 0, __CurrentMeasure )

amitchandak
5 years ago
Anonymous , A measure like

Count of Status Date = VAR __CurrentMeasure =
CALCULATE(
COUNTA('Update'[Status Date]),
eomonth('Update'[Status Date],-1)+1 = DATE(2021, 3, 1)
)
RETURN
IF ( ISBLANK ( __CurrentMeasure ), 0, __CurrentMeasure )

Or based on today

Count of Status Date = VAR __CurrentMeasure =
CALCULATE(
COUNTA('Update'[Status Date]),
eomonth('Update'[Status Date],0)= eomonth(today(),0)
)
RETURN
IF ( ISBLANK ( __CurrentMeasure ), 0, __CurrentMeasure )

4 Replies

amitchandak
Super User
5 years ago
Anonymous , A measure like

Count of Status Date = VAR __CurrentMeasure =
CALCULATE(
COUNTA('Update'[Status Date]),
eomonth('Update'[Status Date],-1)+1 = DATE(2021, 3, 1)
)
RETURN
IF ( ISBLANK ( __CurrentMeasure ), 0, __CurrentMeasure )

Or based on today

Count of Status Date = VAR __CurrentMeasure =
CALCULATE(
COUNTA('Update'[Status Date]),
eomonth('Update'[Status Date],0)= eomonth(today(),0)
)
RETURN
IF ( ISBLANK ( __CurrentMeasure ), 0, __CurrentMeasure )
- Anonymous
  Not applicable
  5 years ago
  amitchandak If I want to add condition as below.
  Count month and year only (month=3 and year =2021) and status = completed
  
  Guide me please.
  - amitchandak
    Super User
    5 years ago
    Anonymous , Try like
    
    Count of Status Date = VAR __CurrentMeasure =
    CALCULATE(
    COUNTA('Update'[Status Date]),
    filter('Update' , eomonth('Update'[Status Date],0)= eomonth(today(),0) && 'Update'[status] = "completed"
    ) )
    RETURN
    IF ( ISBLANK ( __CurrentMeasure ), 0, __CurrentMeasure )

Related content