Calculation to start after skipping 12 months and then rolling sum
Hi all, Out data range is for 48 months. We are trying to calculate the running total that should start from 13th month onward considering last 12 months. And for 14th month (next year) this should have Month 2 to Month 13, so on and so forth. A small excel snippet is below. Can we do this in DAX? Much appreciate your inputs.Calculation to start after skipping 12 months and then rolling sum
Hi all, Out data range is for 48 months. We are trying to calculate the running total that should start from 13th month onward considering last 12 months. And for 14th month (next year) this should have Month 2 to Month 13, so on and so forth. A small excel snippet is below. Can we do this in DAX? Much appreciate your inputs. Calculation to start after skipping 12 months and then rolling sum
