Forum Discussion
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...
Greg_Deckler
Community Champion
Community ChampionPandaOnASlide 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] )
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.