Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 a variable and that doesn't appear to be an option)
Solved! Go to Solution.
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.
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.
Here is a sample table. It's just a list of dates. What I'm trying to do is count the number of rows in the table that have a Best Known Closing date greater than 11 days from today
Best Known Cloisng Date |
12/01/2022 |
12/10/2022 |
01/15/2023 |
11/15/2022 |
11/30/2022 |
@jdickson ok, try putting the Filter function inside, like this:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
25 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |