Percentage of growth from one fixed date 12 month ago

avendanof — Wed, 22 Nov 2023 19:09:03 GMT

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.

Re: Percentage of growth from one fixed date 12 month ago

Rupak_bi — Wed, 22 Nov 2023 19:40:54 GMT

please share sample data. let's try

Re: Percentage of growth from one fixed date 12 month ago

avendanof — Thu, 23 Nov 2023 17:30:19 GMT

fter a lot of search I´ve found the solution right here: Solved: Re: Growth Rate Function using Productx (Dynamic) - Microsoft Fabric Community

Re: Percentage of growth from one fixed date 12 month ago

avendanof — Thu, 23 Nov 2023 17:30:39 GMT

Thanks anyway

topic Re: Percentage of growth from one fixed date 12 month ago in DAX Commands and Tips

Percentage of growth from one fixed date 12 month ago

Re: Percentage of growth from one fixed date 12 month ago

Re: Percentage of growth from one fixed date 12 month ago

Re: Percentage of growth from one fixed date 12 month ago