Forum Discussion

juju's avatar
juju
Icon for Helper III rankHelper III
9 years ago
Solved

Counting multiple occurrences in a day

  I am using data from an energy monitor which tracks daily genset use.  The attached pbix file shows when the genset started (devicetimestamp) and the amount of energy produced for that time period...
Need Help
  • juju's avatar
    juju
    Icon for Helper III rankHelper III
    9 years ago

    hello! Vvelarde

     

    Thanks so much for setting this up! Waaaay over my head. Not sure I understand your approach but will review carefullly.

     

    However, you have a column called "Working Time ". It is showing "12/30/1899" for all rows. For "Working Time", I wanted to capture the total duration the genset has run for each day - so for instance, on June 2, the genset run twice. I'd like to know the total length of time ( sum of both run occurences for that day ).

     

    The last metric - "Average duration" looks at the duration of each specific run instance, then I intend to take an average of all those instances by day or week or month. 

     

    Hope this helps.  Many thanks.

     

     

     

     

    • Vvelarde's avatar
      Vvelarde
      Icon for Community Champion rankCommunity Champion
      9 years ago

      juju

       

      hi, review the Working Time Format. 

       

      • juju's avatar
        juju
        Icon for Helper III rankHelper III
        9 years ago

        Working perfectly. And I have learnt a lot of new things - using VARs in PowerBI. Thank you.