Percent change using hours

Hi  FOXYBARK ,

I created some data:

Here are the steps you can follow：

1. Create measure.

Measure_cntAccessNumbers = MAX('Table'[cntAccessNumbers])

Measure =
var _cvurrent=
SUMX(
    FILTER(ALL('Table'),
    YEAR('Table'[BADGE_SCAN_TS])=YEAR(MAX('Table'[BADGE_SCAN_TS]))&&
    MONTH('Table'[BADGE_SCAN_TS])=MONTH(MAX('Table'[BADGE_SCAN_TS]))&&
    DAY('Table'[BADGE_SCAN_TS])=DAY(MAX('Table'[BADGE_SCAN_TS]))&&
    HOUR('Table'[BADGE_SCAN_TS])=HOUR(MAX('Table'[BADGE_SCAN_TS]))),[Measure_cntAccessNumbers])
var _PreviousValue=
SUMX(
    FILTER(ALL('Table'),
    YEAR('Table'[BADGE_SCAN_TS])=YEAR(MAX('Table'[BADGE_SCAN_TS]))&&
    MONTH('Table'[BADGE_SCAN_TS])=MONTH(MAX('Table'[BADGE_SCAN_TS]))&&
    DAY('Table'[BADGE_SCAN_TS])=DAY(MAX('Table'[BADGE_SCAN_TS]))&&
    HOUR('Table'[BADGE_SCAN_TS])=HOUR(MAX('Table'[BADGE_SCAN_TS]))-1),[Measure_cntAccessNumbers])
return
DIVIDE(
    _cvurrent - _PreviousValue ,
    _PreviousValue)

2. Result:

There is one more thing to note: if your results are all 0, it may be that you have not set the % format, click your Measure -- Measure tools -- %

Best Regards,

Liu Yang

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