Creating Index Costing

[AlexWoodman]

Hi.

Im trying to create a cost per distance Index that will be grouped due to the month its in.

Data in one table like below but just a small mocked up version

End Point ideally looking like this

[v-jingzhang]

Hi @AlexWoodman 

Sorry I don't understand the expected result. Can you explain how to get it based on the mock data more clearly?

Best Regards,
Community Support Team _ Jing

[harshnathani · Accepted solution]

Hi Alex,

You will need to create a Date Table and link it to the main table.

Create the measures for Total Distance, Total Cost and Total Distance/Cost and display it on a matrix viz.

Attached is .pbix file.

Regards,

Harsh Nathani

[Anonymous]

How to calculate the cost for a server.We can assume any value and suggest how it will happen.Thanks