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...
antlufc's avatar
antlufc
Frequent Visitor
2 years ago

Greg_Deckler - i need to take into account if the MQL is Archived / Not Accpeted and take into account the date of the latest MQL. 

Would be - provide the count of MQLs latest date where the latest event flag = 1 and the stage name = Not Accpted or Archived. 

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    2 years ago

    antlufc OK, how about this? PBIX attached below signature.

    Measure = 
  VAR __Statuses = { "Archived", "Not Accepted" }
  VAR __LatestStatus = MAXX( FILTER( 'Table', [latest event flag] = 1 ), [Stage Name] )
  VAR __MaxDate = MAXX( FILTER('Table', [MQLs latest Date] = 1), [date] )
  VAR __Result = IF( __LatestStatus IN __Statuses, __MaxDate, BLANK() )
RETURN
  __Result