Forum Discussion
Referencing previous month data in a calculated column
I have a user table with new set of monthly data added to the table every month. I have a calculated column that works out user "breach status" based on a few columns in the table I am trying to ...
Hi RY33,
ALternate solution to resolve this , PLease create a duplicate table of previous month and and add +1 to month to the previous month (now duplicate table will have month same as current month).
Then create the composite in duplicate table by concatinating month,userid.
then join current month and duplicate month table on basis of composite key ,
then you can compare two columns and get the difference.