Hi ,
I need to find a way to calculate the percentage of growth from one date selected by a slicer, 12 months in the past. At first view seems easy but the problem is that the idea is to select a date with a slicer and based on the date one year ago and it asosiated value calculate the growth on sales.
I give an example:
Supose I select in an slicer september 2023, then
Sales in september 2022 the sales where 200
Then monthly the sales changes and I want to compare the values with the sales from september 2022 up to September 2023
October 22 Sales:120 formula: 120/200
November 22 Sales:130 formula: 130/200
December 22 Sales:105 formula: 105/200
january 23 Sales:120 formula: 120/200
February 23 Sales:120 formula: 120/200
etc... up to September
September 23 Sales:110 formula: 110/200
But If I change the slicer to november, all the calculations have to move to November 2022 as the base sale, in this case 130.
So all the formulas now take 130 instead of 200.
Is there a way to make this happend in Dax.
The problem is that what i need is that if I change the slicer get the value 12 months back and use it in all values. I´ve tried lot´s of thisng but I can't fix the value.
Thanks for any response.
