Last 24 hours of data

[c5966]

Hi Team,

I am trying to display, last 24 hours of data.

But 

Last24Hours = Now() - 1

is giving me current timestamp. Not all the timestamps from last 24 hours.

Can someone help?

Thanks

c5966

[dax · Accepted solution]

Hi c5666,

The Now()-1 will get only one value. You need to have a datetime column like below, then you could apply measure  and set filter on it

Measure 12 = if(MIN(last24[times])>= Now()-1 && MIN(last24[times])<=NOW(),1,0)

If you don’t have datetime column, you could try to create it by below query

let
    Source = List.DateTimes(#datetime(2019, 7, 23, 0,0,0), 60, #duration(0, 1, 0, 0)),
    #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Changed Type" = Table.TransformColumnTypes(#"Converted to Table",{{"Column1", type datetime}})
    
in
    #"Changed Type"

Best Regards,

Zoe Zhi

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