This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreDid you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now
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
Solved! Go to 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
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
How to calculate the cost for a server.We can assume any value and suggest how it will happen.Thanks
Check out the April 2026 Power BI update to learn about new features.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 37 | |
| 37 | |
| 31 | |
| 21 | |
| 16 |
| User | Count |
|---|---|
| 66 | |
| 56 | |
| 31 | |
| 27 | |
| 22 |