how to use column of table A in table b

[Anonymous]

hi all,

  ihave a requirement that project, plannedhours, actual hours ,startdate,enddate shold be projected in table

i have project, startdate and endate in project table.

Projectid,taskid,actualhours in timesheet table

taskid,projectid,task,plannedhours in task table

relationships are below:

timesheet->project ->task on projectid are relationship

timehseet--------->task on taskid relationship

if i drag plannedhours,task from task table, actual hours from timehseet table and project, ,startdate,enddate from  project table into table visual, i'm getting actual hours summed up, how can i get the actual hours splitted through all tasks & projects??????

i'm getting as below:

project    startdate       enddate          task             plannedhours     Actualhours

ABCD       12/10/2017    12/7/2018        task1             2.00                     15.00

ABCD       12/10/2017    12/7/2018        task2             4.00                     15.00

ABCD       12/10/2017    12/7/2018        task3             1.00                     15.00

ABCD       12/10/2017    12/7/2018        task4             2.00                     15.00

ABCD       12/10/2017    12/7/2018        task5             2.00                      15.00

-----------------------------------------------------------------------------------------------------

                                                                                    10.00                     15.00

but the actualhours should be splitted for each task. suppose for task1 actualhours are 4, then under actual i shud get 4.00 for task1

how can i write a DAX for it.

pls help..thanx in advance..

[PattemManohar]

@Anonymous It will be great, if you can post sample data for three tables separately to make it very clear of your requirement and will also help to resolve the scenario quicker !!

[Anonymous · Accepted solution]

Hi pattemmanohar,

 thanx for ur reply, i could solve that issue (as the requirement changed for me)..