Show values only for a single day

[Syndicate_Admin]

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.

[v-binbinyu-msft]

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]

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.

[v-binbinyu-msft]

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

[Syndicate_Admin]

I have created in excel a reduced version of what I have in the report, I hope this helps you to understand the calculations. My goal is to find the table in yellow, that is, to show the average per hour for the date range.

Thanks a lot.

[v-binbinyu-msft · Accepted solution]

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.