Forum Discussion
Solved
AverageIf Syntax for Power BI
Can you suggest syntax in DAX for below Excel formula
PradeepVarma
You can a calculated column to your table as follows: Replace Table with your table nameMTBF = CALCULATE( AVERAGE(Table[Day Between Next Brk]), ALLEXCEPT(Table,Table[System Name]) )________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
Fowmy
Super User
Super UserPradeepVarma
You can a calculated column to your table as follows: Replace Table with your table name
MTBF =
CALCULATE(
AVERAGE(Table[Day Between Next Brk]),
ALLEXCEPT(Table,Table[System Name])
)
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂