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 (cancell...
If using formulas please check as variant in attached.
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.
- Thanks a lot bro
