Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago
Solved

undefined

Good community!!! I am trying to create a MEASURE or COLUMN to display on a card the average value of the last hour. I know, that in a table organizing the hierarchies of Date and Time I can sho...
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi Syndicate_Admin ,

    According to your description, I download your sample, here's my solution.

    Create a measure.

    Promedio_Nivel = 
CALCULATE (
    AVERAGE ( muestra[Nivel_1] ),
    FILTER (
        ALL ( 'muestra' ),
        HOUR ( 'muestra'[Fecha_Hora] )
            = MAXX ( ALL ( 'muestra' ), HOUR ( 'muestra'[Fecha_Hora] ) )
    )
)

    Get the correct result without a slicer.

    I attach my sample below for reference.

     

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please considerAccept it as the solution to help the other members find it more quickly.

v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
4 years ago

Hi Syndicate_Admin ,

According to your description, I download your sample, here's my solution.

Create a measure.

Promedio_Nivel = 
CALCULATE (
    AVERAGE ( muestra[Nivel_1] ),
    FILTER (
        ALL ( 'muestra' ),
        HOUR ( 'muestra'[Fecha_Hora] )
            = MAXX ( ALL ( 'muestra' ), HOUR ( 'muestra'[Fecha_Hora] ) )
    )
)

Get the correct result without a slicer.

I attach my sample below for reference.

 

Best Regards,
Community Support Team _ kalyj

If this post helps, then please considerAccept it as the solution to help the other members find it more quickly.