Here you go! See the attached project. In the project you can change parameter Date to any date in December 2016 and it will generate random data from December 1st to that date, then transpose it and calculate an IF statement for last two columns. The expression works correctly, regardless of the selected date range.
Project: dealing with matrix table columns.morph (5.3 KB)
Screenshot
