Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

datediff between first and lastdate

Hi,   I need a measure to calculate the time between the first and last delivery date per Purchase order   The table is such as:   Receivedorderline Purchase order Receivedate 1 1 1-1...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    Anonymous

     

    hi, Use a measure 

     

    DaysDiff = DATEDIFF(Min(Table1[Receivedate]),MAX(Table1[Receivedate]),DAY)

     

    Now Put in a visual the PO and this Measure.

     

     

     

Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

Anonymous

 

hi, Use a measure 

 

DaysDiff = DATEDIFF(Min(Table1[Receivedate]),MAX(Table1[Receivedate]),DAY)

 

Now Put in a visual the PO and this Measure.