Calculate with dates (30 days before)

[vinicius_ramos]

Hello, 

I need to do a measurement that calculates only what appears 30 days back, for example:

considering today(yyyy-mm-dd): 2023-04-06.

Date (yyyy-mm-dd):	After 30 days:
2023-03-15	Y
2023-01-28	Y
2023-04-01	N
2023-04-03	N
2023-03-20	N
Total	2

In this case i have 5 dates and only 2 dates are 30 days back. I need a measure that do this calculation.

Anybody can help me? 

Thanks a lot.

[FreemanZ · Accepted solution]

hi @vinicius_ramos 

try like:

Measure =

COUNTROWS(

    FILTER(

        TableName,

        TableName[Date]<TODAY()-30

    )

)

[FreemanZ · Accepted solution]

hi @vinicius_ramos 

try like:

Measure =

COUNTROWS(

    FILTER(

        TableName,

        TableName[Date]<TODAY()-30

    )

)

[vinicius_ramos · Accepted solution]

tks a lot !