Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 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
    3 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.

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Syndicate_Admin ,

    Please set the filter in the "Filter Pane" for the table visual according to your needs.

    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.

    • Syndicate_Admin's avatar
      Syndicate_Admin
      Icon for Administrator rankAdministrator
      3 years ago

      Hello, maybe I did not express myself well. My goal is to calculate the average spread for the date range shown in the table and per hour. Now, with the formula I have it shows me the same value for every day and if I do what you put me before, in the average I see the same value as the spread.

      Attached photo of the formula and table.

      Thanks a lot.

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hi Syndicate_Admin ,

        Please provide the desensitized example data, the calculate logic and a screenshot of your desired results.

        Thanks for your efforts & time in advance.

         

        Best regards,
        Community Support Team_ Binbin Yu