Forum Discussion

DKwustl's avatar
DKwustl
New Member
3 years ago
Solved

Displaying the latest date with comment correctly

I am having issues with a tracking report I have created. The data looks like the following within the database:   Item Type Event Time User Comment Workstation Slide A 1/4/23 12:37pm J...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    DKwustl Maybe:

    Last scan status measure = 
  VAR __LastScanDate = MAX('Table',[Event Time])
  VAR __LastStatus = MAXX(FILTER('Table',[Event Time] = __LastScanDate),[Comment])
RETURN
  __LastScanDate
Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

DKwustl Maybe:

Last scan status measure = 
  VAR __LastScanDate = MAX('Table',[Event Time])
  VAR __LastStatus = MAXX(FILTER('Table',[Event Time] = __LastScanDate),[Comment])
RETURN
  __LastScanDate
DKwustl's avatar
DKwustl
New Member
3 years ago

I feel like this is working but I want to make sure with todays results. I still had one that did not display the correct comment. It makes me feel it could be a scanning issue.