Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago
Solved

Show values only for a single day

Good morning, in the attached table I am calculating the mean and deviation for the date range shown and per hour. My goal is to display those two values for each hour only for the last day of the range so that I don't see duplicate values for every day.

  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Syndicate_Admin ,

    Please try below steps:

    1. create some measures with below dax formula

    Measure = MAXX('Table',[Date])
    Hour1 =
VAR cur_date = [Measure]
VAR tmp =
    FILTER ( ALL ( 'Table' ), 'Table'[Date] <= cur_date )
RETURN
    AVERAGEX ( tmp, [H1] )

    There are 8 measures that named "Hour 1-8", they are very likely.

     

    2. add the measure to the table visual

    Please refer the attached .pbix file.

     

    Best regards,
    Community Support Team_ Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.