cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CCAIXE New Member
New Member

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?

1 REPLY 1
Moderator v-yuezhe-msft
Moderator

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

@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,

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.