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.

Thank you

Need Help

2 Replies

  • 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