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.
Hi All,
I need to count the number of closed tickets in a table between 2 dates.
I have a date table connected to my data table
To get a closed date I had to use an if statement:
Solved! Go to Solution.
Hi @Anonymous ,
To create a measure as below.
Measure =
CALCULATE (
COUNTROWS ( Query1 ),
FILTER (
Query1,
Query1[Closed Date] >= DATE ( 2018, 08, 01 )
&& Query1[Closed Date] <= DATE ( 2019, 07, 31 )
)
)
If it doesn't meet your requirement, kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.
Hi @Anonymous ,
To create a measure as below.
Measure =
CALCULATE (
COUNTROWS ( Query1 ),
FILTER (
Query1,
Query1[Closed Date] >= DATE ( 2018, 08, 01 )
&& Query1[Closed Date] <= DATE ( 2019, 07, 31 )
)
)
If it doesn't meet your requirement, kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.
Worked perfectly, thanks
Hi @Anonymous
Try this as a measure:
Closed Tickets =
CALCULATE (
COUNTROWS ( Query1 ),
DATESBETWEEN (
Calendar,
DATE ( 2018, 08, 01 ),
DATE ( 2019, 07, 31 )
)
)
You can, of course, make this a dynamic measure by replacing the hardcoded dates in the DATESBETWEEN function.
Hope it helps.
Best regards,
Martyn
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 |
---|---|
112 | |
96 | |
78 | |
68 | |
55 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |