Forum Discussion
Applying Equipment Costs to My Project Column
Community Supporti checked your pbix file. the 'Plant & Vehicles_Jonas'[Job_Number] have no item in 'Jobs_Jonas'[Job_Number].
so the job name in projectslist can not match the job_number in Plant & Vehicles_Jonas.
please check if the projectslist or Plant & Vehicles_Jonas is complete.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-chenwuz-msft ,
so the list of jobs, and the list of plant are seperate, not incomplete; but where a piece of plant from "Plant & Vehicles_Jonas" has been assigned to that project for that day using "Day Docket", i would like to apply the average daily cost of that plant to the Project in
The Job filter appears to recognize the count of the amount of time that Plant was on the site as it filters the tables correctly using the measure day diary plant days;
i suppose what i would like to achieve is
where "Day Diary Plant Days" x "Avg Plant & Vehicle cost per day" and somehow assign that $ value to that project based on those parameters;
i have attempted to Crossjoin the two tables to create a relationship but that didnt appear to work;
i understand if the relationship i am trying to create is not possible with my Data structure, and i grealy appreciate your time in looking into it and coming to this conclusion regardless,
Kind regards,
James