Count date column rows based on another table column date

[Anonymous]

Hi,

Table 1 has date column, 

Table 2 have created calendar days.

Need to get count in table 2 from table 1 based on table 2 calendar  days.

Have tried this Dax formula Test = COUNTROWS(FILTER('Raw Data Report','Raw Data Report'[Created Date]>=MAX('Calendar_days'))) but it says error " The MAX function only accepts a column refrences as an argument"

[v-yuta-msft · Accepted solution]

Hi MuraliMani ,

Modify you DAX formula like this:

Test =
COUNTROWS (
    FILTER (
        'Raw Data Report',
        'Raw Data Report'[Created Date] >= MAX ( 'Calendar_days'[Date] )
    )
)

Regards,

Jimmy Tao