Count based on Same date Case

[Anonymous]

OK. I can't think of a solution to this problem. We have two columns, the date received and the date completed. Our goal is to complete all cases the same day, but sometimes, cases might be completed the next day. A real case is that on 05/20, we received 13 cases and completed 10, but the other three are from cases received on 05/19 that were completed on 05/20.

What I want is to show the received vs completed from the same day. We also have a case number column

Thanks 

[amitchandak]

@Anonymous ,

received =count(Table[caseId])
completed same date= calculate(count(Table[caseId]), filter(table,table[date received] =table[date completed]))

Make sure you use date table and joined with date received

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/

See if my webinar on Time Intelligence can help: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-YTD-LYTD-Week-Over-Week/m-p/1051626#M184


Appreciate your Kudos.

[Anonymous]

Thanks for the quick answer. The DAx  Received worked. Completed same date shows blank.

completed same date = calculate(count('Menu Tracker V2 0 (2)'[Case Number]), filter('Menu Tracker V2 0 (2)','Menu Tracker V2 0 (2)'[Timestamp Received] ='Menu Tracker V2 0 (2)'[Time Completed]))

[az38]

Hi @Anonymous 

I do not see your data, but I think it's not your case when time received is equal time completed

It seems you told about Date. so, try smth like

completed same date = calculate(count('Menu Tracker V2 0 (2)'[Case Number]), filter('Menu Tracker V2 0 (2)','Menu Tracker V2 0 (2)'[Timestamp Received].[Date] ='Menu Tracker V2 0 (2)'[Time Completed].[Date]))