Forum Discussion

CCAIXE's avatar
CCAIXE
New Member
9 years ago

How do I count rows with date less than today using direct query

Hi, 

 

how do i count rows whit date lass then today using direct query?

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    CCAIXE,

    You connect to your data source using "DirectQuery" mode, right? If so, create a measure in your table using the DAX below.

    Measure = CALCULATE(COUNTROWS('TableName'),FILTER('TableName','TableName'[Date]<TODAY()))



    Regards,