Forum Discussion

AllanBerces's avatar
AllanBerces
Post Prodigy
2 years ago

Adding Calculated Column but Data from other Table

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. Th...
Need Help
Sivakumar_H's avatar
Sivakumar_H
Helper I
2 years ago

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's avatar
    AllanBerces
    Post Prodigy
    2 years ago

    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