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 🙂
1 Reply
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 🙂