Forum Discussion

Saitharunk's avatar
Saitharunk
Frequent Visitor
3 years ago
Solved

Show average time taken between work order creation for the same asset

  I want to find the average of "Workorder Created Date " related to "Assert Name column " . I have shared an example below table , can anyone help me please ... to create in power bi.  ...
Need Help
  • DOLEARY85's avatar
    DOLEARY85
    3 years ago

    Hi,

    try this measure:

     

    Average = calculate(DATEDIFF(min('Table (8)'[WO Created Date]),max('Table (8)'[WO Created Date]),DAY))/calculate(CALCULATE(count('Table (8)'[Asset Name]))-1)

     

     
DOLEARY85's avatar
DOLEARY85
Icon for Resident Rockstar rankResident Rockstar
3 years ago

Hi,

try this measure:

 

Average = calculate(DATEDIFF(min('Table (8)'[WO Created Date]),max('Table (8)'[WO Created Date]),DAY))/calculate(CALCULATE(count('Table (8)'[Asset Name]))-1)