I was curious due to the image of the Data Table in the question and took a peek. To help members of the Community Forum understand the state, would you please add the following to your posting:
-
Expand on your description of the model, and add images and a description of your desired result so that someone who is unfamiliar with your line of business is able to make a fair assumption towards a working solution.
-
Please add the following missing source Excel files:
C:\EDNA\TData.xlsx
C:\EDNA\TEquipRates.xlsx -
Would you please update the attached sample PBIX, by adding a dedicated Date Table as the default? Recommend using our Extended Date Table (Power Query M function),
-
Would you please set up the relationships to accommodate a working model? Currently, No relationships appear linking the two tables in the model (Data and EquipRates).