Matrix Table

Hello Ylong, 

Thanks for your reply. te measure you provided is good. The only problem is that the total has to have an IF statement that depends on a measure. The first weeek of the matrix is actually a COUNT of all the units that have a "yes" in the occupied column. 

If I were to do the same thing in any other programming language I would use a while loop. In pseudocode it should be something like:
total1=  [actual occupied units] + [ins] - [out]
total2= total1 + [ins] - [out]
i= 1
WHILE 

    counter < MAX(weekcount)
          IF weekcount = 1 
              total1
          else 
              total2 
               total2 =total2 + ins - out
       i ++
This should create a loop that iterates through the weeks. Unfortunately, PBI doesn't have while loops and the  variables are static.