Forum Discussion
Count based on Same date Case
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
3 Replies
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.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]))
