Forum Discussion

kylebi1's avatar
kylebi1
Frequent Visitor
7 years ago

Filter Latest Date and Value for each Row

I have a table that looks like the following:   Name Workgroup Active Modified Date Time Kyle A 1 10/7/2018 Kyle A 0 10/8/2018 Kyle B 0 10/7/2018 Kyle B 1 10/8/2018 ...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
7 years ago

So, can you explain the expected results from the sample data presented and to logic to arrive at that result?

kylebi1's avatar
kylebi1
Frequent Visitor
7 years ago

Hi Greg_Deckler

 

I need the current status for each user and their workgroup. I was able to filter for the latest modified date time for each workgroup using this measure:

 

CALCULATE(SUM(   'Workgroup Table'[ActivationFlag]), FILTER('Workgroup Table', 'Workgroup Table'[ActivationDateTime]=MAX('Workgroup Table'[ActivationDateTime])))