Forum Discussion

drivas771994's avatar
drivas771994
Helper II
7 years ago
Solved

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...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    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

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

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