Forum Discussion

antlufc's avatar
antlufc
Frequent Visitor
2 years ago

Different Dates based upon 2 different columns

The table below shows MQLs by latest date and latest event flag.  I would like to show the volume of MQLs that are Not Accepted or Achived using the MQLs - latest date.    So in my below example...
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
2 years ago

antlufc Not sure I fully understand but perhaps something like:

Measure =
  VAR __Table = FILTER('Table', [MQLs latest Date] = 1)
  VAR __MaxDate = MAXX( __Table, [date] )
RETURN
  __MaxDate