Forum Discussion

AlexWoodman's avatar
AlexWoodman
Regular Visitor
4 years ago
Solved

Creating Index Costing

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

 

 

 

Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    4 years ago

    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

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      3 years ago

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

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    4 years ago

    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