Forum Discussion

PandaOnASlide's avatar
PandaOnASlide
Frequent Visitor
3 years ago

Finding Earliest Date When ID Changes

Hi all,

 

I've looked around for a solution here but can't seem to find one that fits my situation.

 

I have a list of names along with a promotion ID and a promotion date. They can be promoted multiple times within the same promotion ID, so there are multiple instances of each name along with promotion IDs and Dates.

 

I want to find out the earliest date when a commission ID = 2 for each name and each carrier. I've attached a table below for reference. Any help is appreciated! 

Need Help

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    3 years ago

    PandaOnASlide So generally you would put name and carrier in a table visualization and then something like this:

    Min Date CommID 2 Measure = MINX( FILTER( 'Table', [CommissionTypeId] = 2 ), [PromotionDate] )
    • PandaOnASlide's avatar
      PandaOnASlide
      Frequent Visitor
      3 years ago

      Greg_Deckler  That worked, thank you!

      Am I able to apply this as a filter of some kind? I want to be able to see the data from the same agent when they were Commission Type 1. Currently it'll only give me Commission Type 2 data, even if I filter before the change date.