Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Matrix aggregation and filtering

Hi,  I need to group values in the matrix by Source and Destination columns.  How can I achive this? Thanks for any advice   Previous Segment = Source Currenct Segment = Destination ...
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Anonymous 

Please try

Source =
VAR SelectedDate =
MIN ( 'Calendar'[Date] )
VAR CurrentIDTable =
FILTER ( 'Table', 'Table'[segment date] > SelectedDate )
VAR FirstRecord =
TOPN ( 1, CurrentIDTable, 'Table'[segment date], ASC )
RETURN
MAXX ( FirstRecord, 'Table'[segment_name] )