Count of Max Date with relative date filter

[LeahS]

Hi,

I am trying to count the max "date of service" against a relative time period such as today-14.  Below is my current code but I keep getting an error stating the true/false has to specify one column, but I'm only using one column.  Any ideas?

CALCULATE(count(transactions[date_of_service]), max(transactions[date_of_service]) <= (TODAY()-14))

[Anonymous]

Hi @LeahS,

we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Regards,
Vinay Pabbu

[Anonymous]

Hi @LeahS,

we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Regards,
Vinay Pabbu

[Anonymous]

Hi @LeahS,

we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Regards,
Vinay Pabbu

[bhanu_gautam · Accepted solution]

@LeahS , Try using

DAX
CALCULATE(
COUNT(transactions[date_of_service]),
FILTER(
transactions,
transactions[date_of_service] <= (TODAY() - 14)
)
)