Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Subtracting Grouped Rows in Different Tables

Hello,   I'm managing construction locations and I have 2 tables. Here are a few sample columns.   Table 1 (Locations) Work Order # Work Location Tag 7970386 A 7970386 B 7970386 ...
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hey all,

     

    Thanks for the help. I ended up figuring out the solution. Here's the equation below...

     

    In Progress/Complete Locations = countx(filter('Table1', 'Table1'[Work Order #] = 'Table 2'[Work Order #]), 'Table1'[# of Locations Complete/In Progress])

Not Started Locations = Total Construction Locations - In Progress/Complete Locations
amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous , Not very clear

New column in Table 2

if(isblank(Countx(filter(Table1,table1[Work Order #] =table2[Work Order #]),[Work Location Tag])),"Not Started","In Progress")

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hello amitchandak ,

     

    Apologies. I am looking for a number value.

     

    For example if I have a WO with 21 Total Construction Locations from Table 2 and I have 5 Locations listed in Table 1 under that WO, I would like a column in Table 2 to say 16 Locations Not Started for that WO.

     

    Robyn