Hi all. I'm creating a KPI dashboard for my department. One of the KPI's we measure is % customer cases closed by month, quarter year, etc. I've created the measures and they work when i choose the appropriate year and month date slicers. However i'd like to have it calculate based on the date of the most recent transaction/case entered in our system. I.e if the most recent customer case is March 10th, calculate % MTD. The idea being this is can float from month to month without me having to click the date slicers each time and i can then share these KPI's with my sr. management team without them needing to do any additional clicking.
My current measure which works with date slicers:
% Closed MTD = TOTALMTD([% Tickets Closed],'Calendar'[Date])
For what I want to do i assume i'll need some type of FILTER which looks into my 'incidents' table determines the date of the last customer case that was logged into our system, then reverse calculates the first date and last date of the month). But I'm struggling with where to start... as i'm fairly new to DAX, but hungry to learn. Don't need final solution but if i can be pointed in which direction to go...
Thank you
My current measure which works with date slicers:
% Closed MTD = TOTALMTD([% Tickets Closed],'Calendar'[Date])
For what I want to do i assume i'll need some type of FILTER which looks into my 'incidents' table determines the date of the last customer case that was logged into our system, then reverse calculates the first date and last date of the month). But I'm struggling with where to start... as i'm fairly new to DAX, but hungry to learn. Don't need final solution but if i can be pointed in which direction to go...
Thank you