Forum Discussion
Solved
Average delivered and cost
Hello how to calculate this details from the data set below ?
1. Average delivered order duraton in UA
2. Average delivered order duration in Kyiv
3. Average percentage of cancelled orders (cancelled orders/total orders) for each city
4. Average percentage of cancelled orders in UA
5. Cost per delivered order in UA6. Cost per delivered order in Kyiv
1. Average delivered order duraton in UA
2. Average delivered order duration in Kyiv
3. Average percentage of cancelled orders (cancelled orders/total orders) for each city
4. Average percentage of cancelled orders in UA
5. Cost per delivered order in UA6. Cost per delivered order in Kyiv
If using formulas please check as variant in attached.
4 Replies
tatto330 ,
You need to specify country and city exactly in the table. Excel has no idea that Odesa is UA and "Kyiv left bank" is Kyiv, sorry for that. With exactly specified country/city you may load data to data model and use DAX measures to calculate what is required aggregating the result into PivotTable. But first step is proper classification.
- Hello please see attached document
If using formulas please check as variant in attached.
