Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Calculate last hour data

Hi all,   I'm pretty new in Power BI, I'm seeking a solution calculate last specific hour. As I searched on Google, Power BI has a DATEADD function can help this but this function just only suppor...
Need Help
az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

Anonymous 

what is your desired result for this data sample?

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi az38 ,

     

    My desired result if last 2 hours is:

     

    TimeCountcount last 2 hours
    01/01/2018 10:00:00 PM4 
    01/01/2018 11:00:00 PM2 
    02/01/2018 12:00:00 AM24
    02/01/2018 01:00:00 AM62
    02/01/2018 02:00:00 AM42
    02/01/2018 03:00:00 AM96
    02/01/2018 04:00:00 AM04

     

    • az38's avatar
      az38
      Icon for Community Champion rankCommunity Champion
      6 years ago

      Anonymous 

      it depends on how  you calculate count but try

      Measure = CALCULATE(SUM([Count]), FILTER(ALL('Table'), DATEDIFF('Table'[Time], SELECTEDVALUE('Table'[Time]), HOUR)=2))

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hello Anonymous ,

         

        I currently cannot get the desired result.

        Let me clarify a little bit, It's similar like DATEADD but applied for HOUR.

        I cannot use this function due to the Time field data has the duplicate date.