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 m...
Need Help
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.