Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Calculate shipment frequency with a variable for 2022

Hi everyone !    I am having a problem calculating my shipping frequency. I have a database that starts from 2018 to today and I would like to know how many days a shipment takes place.   Exampl...
  • amitchandak's avatar
    4 years ago

    Anonymous , Try a measure like

    divide(datediff(min(Database[CurrShipmentStart]), max(Database[CurrShipmentStart]), day), DISTINCTCOUNT(Database[Descrip.of Shipment]))