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
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hello lbendlin ,

 

Adding to this question, I can neither write a Measure nor a Calculated Column inside of that table using Average Function for the MTBF33. Also, PowerBI also does not allow me to select SUM, AVERAGE, MIN, MAX dropdown from the MTBF33 shown in the visual above in the Y-axis. 

 

I think applying average for the MTBF for all those individual equipments for each of the respective month will solve this problem but I don't know how to go about solving it?

 

Thanks

lbendlin's avatar
lbendlin
Super User
1 year ago
How do I get the MTBF for all those necessary Equipments for each respective months?

I have no idea how this would logically even be possible.

 

Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago
    EquipmentCommissioned DateBreakDown Date
    A02/01/202403/15/2024
    B01/01/202402/01/2024
    C01/15/202402/15/2024
    A02/01/202402/28/2024
    B02/20/202403/20/2024
    C03/01/202403/27/2024
       
       
       

     

    Hello lbendlin ,

     

    I have added a dataset to recalculate the MTBF for February and March 2024. I am fine with your earlier formula of 

    MTBF = var a = values('MergedTable'[BreakDate]) return if(HASONEVALUE(MergedTable[Equipment]),DIVIDE(maxx(a,[BreakDate])-minx(a,[BreakDate]),COUNTROWS(a)-1))

     

    But this time, I want the MTBF for February and March of 2024 instead of individual equipments. 

     

    Can you please suggest the DAX code in consistent with the formula above?

     

    Thank you again! 

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago
    I want the MTBF for February and March of 2024

    I don't know what that means.  Do you want the MTBF for equipments that were commissioned in these months?

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hello lbendlin ,

     

    Yes, I want the MTBF on the Y-axis and Months on the X-axis. MTBF should include all the Equipments for that particular month. 

     

    Thank you! 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hello lbendlin ,

     

    I am just following up to see if you have made any progress to figure it out?

     

    Thanks

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

    What does " for that particular month. "  mean?  Commissioned in that month? Having a failure in that month?

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hello lbendlin ,

     

    Since we are calculating Mean Time Between Failure, I think we should use BreakDate for that particular month which should be the X-axis. 

     

    Thanks,