Como calcular o total da ultima data/hora/minuto?

[Victor1986]

Como calcular o TOTAL_EVENTOS na ultima data/hora/minuto do campo DATA_UPDATE) ?

[Anonymous · Accepted solution]

Hi @Victor1986 ,

Please use the following three dax formulas:

Calculate the TOTAL_EVENTOS the last date of the DATA_UPDATE:

LastDate_Total =
VAR maxdate =
    CALCULATE ( MAX ( 'Table (2)'[Date_Update] ), ALL ( 'Table (2)' ) )
RETURN
    CALCULATE (
        SUM ( 'Table (2)'[TOTAL_EVENTOS] ),
        FILTER (
            ALL ( 'Table (2)' ),
            'Table (2)'[Date_Update].[Date] = DATEVALUE ( maxdate )
        )
    )

calculate the TOTAL_EVENTOS the last hour of the DATA_UPDATE:

LastHour_Toatal =
VAR maxdate =
    CALCULATE ( MAX ( 'Table (2)'[Date_Update] ), ALL ( 'Table (2)' ) )
RETURN
    CALCULATE (
        SUM ( 'Table (2)'[TOTAL_EVENTOS] ),
        FILTER (
            ALL ( 'Table (2)' ),
            'Table (2)'[Date_Update].[Date] = DATEVALUE ( maxdate )
                && HOUR ( 'Table (2)'[Date_Update] ) = HOUR ( maxdate )
        )
    )

Calculate the TOTAL_EVENTOS the last minute of the DATA_UPDATE:

LastMinutes_total =
VAR maxdate =
    CALCULATE ( MAX ( 'Table (2)'[Date_Update] ), ALL ( 'Table (2)' ) )
RETURN
    CALCULATE (
        SUM ( 'Table (2)'[TOTAL_EVENTOS] ),
        FILTER (
            ALL ( 'Table (2)' ),
            'Table (2)'[Date_Update].[Date] = DATEVALUE ( maxdate )
                && HOUR ( 'Table (2)'[Date_Update] ) = HOUR ( maxdate )
                && MINUTE ( 'Table (2)'[Date_Update] ) = MINUTE ( maxdate )
        )
    )

If I misunderstand your demands, please feel free to let me know .

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.