% growth

2 Topics

Previous month % - error
Hello, I'm trying to calculate previous month difference % in the attached dashboard. As you can see, the previous month function does not work properly at all and shows strange percentages. Sometimes % is missing etc. Does anybody know what I'm doing wrong? Can somebody help please? I'm attaching PowerBI Desktop file: https://drive.google.com/file/d/1MR9BP7BwVnnF_pH26VqLhHfNwVaTLTqF/view?usp=drive_link
Solved
lucie_rabochova
2 years ago Place DAX Commands and Tips
2.1KViews
0likes
10Comments
Percentage of growth from one fixed date 12 month ago
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.
Solved
avendanof
2 years ago Place DAX Commands and Tips
868Views
0likes
3Comments