Forum Discussion

FlyKick's avatar
FlyKick
Helper II
6 years ago
Solved

Counting Rows By Date Column Where The Date Is Between A Specific Period

Hi All,   I have two tables one holds all my data and the other is a Date table that I have created in M Query.    Tickets Table  Ticket Number, Entered DateTime, Closed DateTime, EnteredDateOnl...
Need Help
  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    6 years ago

    Hi FlyKick ,

     

    If your X axis uses Tickets table's Date, you can create a measure and put it in Filter on this visual. Configure it as 1.

    Measure = 
IF(
    MAX(Tickets[ClosedOnDateOnly])>=MIN('Date'[Date]) && MAX(Tickets[ClosedOnDateOnly])<=MAX('Date'[Date]),1,0)

     

     

    If your X axis uses Date table's Date, please try to delete the relationship between the date table and Tickets table.

     

    If it doesn’t meet your requirement, could you please provide a mockup sample based on fake data?

    It can help us reproduce your issue.

     

    Please upload your files to OneDrive For Business and share the link here. Please don't contain any Confidential Information or Real data in your reply.

     

    Best regards,

     

    Community Support Team _ zhenbw

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

FlyKick's avatar
FlyKick
Helper II
6 years ago

Here is the result of adding the ALLEXCEPT function.

 

v-zhenbw-msft's avatar
v-zhenbw-msft
Community Support
6 years ago

Hi FlyKick ,

 

How about the result after you follow the suggestions mentioned in my original post?

Could you please provide more details or expected result about it If it doesn't meet your requirement?

If you've fixed the issue on your own please kindly share your solution. If the above posts help, please kindly mark it as a solution to help others find it more quickly.

 

Best regards,

 

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.