Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Example for 2021 I calculated it like this:
Shipment frequency 2021 = iferror(CALCULATE(365/DISTINCTCOUNT(Database[Descrip.of Shipment]), FILTER(Database, Database[CurrShipmentStart].[Année]=2021)),BLANK())
And for 2022 =
Solved! Go to Solution.
@Anonymous , Try a measure like
divide(datediff(min(Database[CurrShipmentStart]), max(Database[CurrShipmentStart]), day), DISTINCTCOUNT(Database[Descrip.of Shipment]))
Hello,
Thank you for your answer.
It works 🙂
@Anonymous , Try a measure like
divide(datediff(min(Database[CurrShipmentStart]), max(Database[CurrShipmentStart]), day), DISTINCTCOUNT(Database[Descrip.of Shipment]))
User | Count |
---|---|
76 | |
74 | |
61 | |
61 | |
45 |
User | Count |
---|---|
108 | |
103 | |
93 | |
83 | |
64 |