Forum Discussion
jdickson
3 years agoNew Member
Count Rows based on a DATEDIFF Value greater than a specific amount
I'm trying to create a measure that counts the rows of a table if the DATEDIFF between a date field in the table and today is greater than 11. The DAX query I have is below. (I'm trying to filter by ...
- 3 years ago
Hi jdickson ,
//DATEDIFF ( <Date1>, <Date2>, <Interval> )
The result is positive if Date2 is larger than Date1.
The result is negative if Date1 is larger than Date2.
Pay attention to the order of the two dates
Best Regards,
Gallen Luo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-jialluo-msft
3 years agoCommunity Support
Hi jdickson ,
//DATEDIFF ( <Date1>, <Date2>, <Interval> )
The result is positive if Date2 is larger than Date1.
The result is negative if Date1 is larger than Date2.
Pay attention to the order of the two dates
Best Regards,
Gallen Luo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.