Adding Calculated Column but Data from other Table

[AllanBerces]

Hi good day,

Can anyone know how, How can i created new column on Table 1 but data is from Table 2 . But Table 2  i need to filter from current date, Category, Task Phase and Sub category.

Thank you

[Sivakumar_H]

@AllanBerces  try to change bi directional filter from Daily SQL table and Dimension Calendar, Then Use CALCULATE & RELEATED function in Table 1 to create calculate column based on filter condition required.

[AllanBerces]

Hi Sivakumar,

Can you tech me how try code it corretly.

Column = SUMX(RELATEDTABLE('Daily SQL'), 'Daily SQL'[Current Date](FILTER('Daily SQL','Daily SQL'[WON]="NC000172" && 'Daily SQL'[Task Phase] = "PRECPRA"), 'Daily SQL'[Earned last 24 hrs]))

They are all connected in date.

Thank you