1 Reply Latest reply on Jul 7, 2017 12:53 PM by Stephen Rizzo

    Creating Week over Week Variance based on one date column

    Amol Bhondave

      Hello,

       

      I'm trying to create a week over week variance based on one date column, say "A" (7/3/2017 14:25:12). On the basis of that date column, i have certain measures (B,C,D) that change its values based on column A. Every time i refresh my SQL query, col A (7/7/2017 14:25:00) changes and so does values for B,C and D. The data set doesn't retain the old values for those columns. I want to calculate the variance for B,C and D based on col A, before and after my data refreshes.

      Can anyone help me with a calculation that can help me get the variance based on the above condition?