Forum Discussion
pulling up most recent data filter for a table
Hi,
I'm trying to create a column that shows a jump height for an athlete on that day. Currently, it is giving me the average for the filtered time frame I have but I want this specific column to show me the value for the most recent submitted day. Is it possible to do this? The column that I would want to have the most recent data for is the daily jump column. All the other columns are filtered based on submissions from the last 30 days.
Hi drivas771994,
Suppose there is a submission date column in source data table. To make sure that all the columns in table visual except for Daily Jump are filtered based on submissions from the last 30 days, please add the [date] field into visual level filter.
To show the value of Daily Jump in the most recent submitted day, please refer to below measures:
recent date = CALCULATE ( MAX ( Table2[Date] ), ALLSELECTED ( Table2[Date] ) ) daily jump = CALCULATE ( SUM ( Table2[Jump] ), FILTER ( ALLSELECTED ( Table2[Date] ), Table2[Date] = [recent date] ) )Best regards,
Yuliana Gu
1 Reply
Hi drivas771994,
Suppose there is a submission date column in source data table. To make sure that all the columns in table visual except for Daily Jump are filtered based on submissions from the last 30 days, please add the [date] field into visual level filter.
To show the value of Daily Jump in the most recent submitted day, please refer to below measures:
recent date = CALCULATE ( MAX ( Table2[Date] ), ALLSELECTED ( Table2[Date] ) ) daily jump = CALCULATE ( SUM ( Table2[Jump] ), FILTER ( ALLSELECTED ( Table2[Date] ), Table2[Date] = [recent date] ) )Best regards,
Yuliana Gu