Forum Discussion
Solved
Date Tracking for multiple categories
Hello my fellow answer seekers. I am currently using this formula to track the last time a claim was filed: Date of Last Submitted Claim = CALCULATE(MAX('Full_Data'[Date]),FILTER(Full_Data, Full_D...
Well, create a new data set for the example showed me what I was doing wrong. The page the measure is on involves 2 Data set tables where one showcases this year only while the other showcases this and last year. Since the Department filter was showing this year only, it was not populating or understanding that last year there was claims. Adjusting the slicer interactions and adding a this/last year slicer fixed the issue.
Cookistador
Super User
Super UserAre you sure that you do not have another slicer somewhere?
I just made a quick test
This is the small table I created: