Measure monthly average fuel consumption in Pivot Data Model

[primasatria]

Hi all,

I never use Power Pivot, Power Query and DAX since I've been using Excel more than 5 years.
I am using Office 365.

I am creating a Data Model pivot table to know:
- fuel monthly consumption (no problem with this)
- number of vehicle for each month (no problem with this), using distinct count

I need your help, how to measure:
- average monthly consumption (fuel consumption divide by number of vehicle (distinct count))
- monthly ratio of each vehicle ID, based on fuel consumption and driven mileage.

Thanks in advance for your kind attention and assistance.
Best regards,
prima

 

[GraH]

You can use the divide function and use the measures you already made.
Divide(fuel consumption, number of vehicles)

 

[primasatria]

You can use the divide function and use the measures you already made.
Divide(fuel consumption, number of vehicles)

Dear GraH,

Thank you for your kind assistance. I believe this one to find the average of monthly consumption.
But what about the second question, "to find monthly ratio for each vehicle?"

Again, thank you very much.
prima

 

[GraH]

Hello @primasatria ,
Glad I could help.
I guess it is the same kind of solution where you can use divide(total fuel consumption, total mileage driven). Both are again other measures you need to create. The total consumption you already have.

 

[primasatria]

Hello @primasatria ,
Glad I could help.
I guess it is the same kind of solution where you can use divide(total fuel consumption, total mileage driven). Both are again other measures you need to create. The total consumption you already have.

Dear GraH,

Thank you very much.

Best regards,
prima