Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

PowerBI Desktop

Hello PowerBI community      @Amit, @Greg , @tamerj1 , @lbendlin,   @amitchandak , @olgad , @Sahir_Maharaj , @FreemanZ , @tamerj1 , @Greg_Deckler    @christinepayton @audreygerred    @LukeB,...
Need Help
lbendlin's avatar
lbendlin
Super User
1 year ago

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information. Do not include anything that is unrelated to the issue or question.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago
    Equipment         CommissionedDate        BreakdownDate
    A                        02/01/2016                      03/01/2016
    B                         05/14/2010                      07/14/2010
    C                         09/01/2024                     10/15/2024

    D                         05/01/2024                      07/01/2024

    E                          04/01/2024                      04/15/2024

    A                          02/01/2016                     04/01/2016

    B                          05/14/2010                     08/14/2010

    C                          09/01/2024                     11/1/2024 

    A                          02/01/2016                     05/01/2016

    B                          05/14/2010                      09/01/2010

     

    • powerbiexpert22's avatar
      powerbiexpert22
      Impactful Individual
      1 year ago

      Hi Anonymous 

      opertime = DATEDIFF('EquipmentFailures'[CommissionedDate], 'EquipmentFailures'[BreakdownDate], DAY)

       

      totalopertime = SUM('EquipmentFailures'[OperatingTime])

      numberoffailures = COUNTROWS('EquipmentFailures')

      meantimebetwfailures=divide(totalopertime,numberoffailures)