Power BI Mileage Calculator Report
Budget: $250 – $750 USD
I am looking for the following:
I want to be able to refresh power bi that will look at 4 tables in an excel file that I will build and provide
Table 1: Load Locations: This will have the lat longs and market info that I will track
Table 2: Unload Locations: This will have lat longs and market info that I want to track as well
Table 3: Truck rates: I will provide these rates that are based on the mileage from table 1 & 2
What I need done
I want to be able to update these tables at any time, when I do I want to be able to go to power bi & refresh the data to see new results
I have attached an excel sheet showing the three tables of data that will be calculated by me and that is what power bi will refresh off of.
I have added 3 desired outputs that I want to see in Power bi that will be calculated from these tables.
I want to be able to refresh power bi that will look at 4 tables in an excel file that I will build and provide
Table 1: Load Locations: This will have the lat longs and market info that I will track
Table 2: Unload Locations: This will have lat longs and market info that I want to track as well
Table 3: Truck rates: I will provide these rates that are based on the mileage from table 1 & 2
What I need done
I want to be able to update these tables at any time, when I do I want to be able to go to power bi & refresh the data to see new results
I have attached an excel sheet showing the three tables of data that will be calculated by me and that is what power bi will refresh off of.
I have added 3 desired outputs that I want to see in Power bi that will be calculated from these tables.