growth rate
4 Topics
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.Solved869Views0likes3Comments
Calculating Average Growth Rate using last three years
Hi everyone, I am having issue with calculating the average growth rate based on preceding years value, as I calculate the yearly growth rate based on the previous ones value, I want to calculate average growth rate based on the values from last recent three years for example if 2019's rate is 4%, 2020's rate is 3% and 2021's rate is 5% I want average rate of 12/3 = 4%. Here is sample snap of my data: Sales ID Product Name Date Net Sales 1 Mercedes 17/04/2019 £11,500.00 2 Belta 17/04/2020 £6,000.00 3 Lamborghini 28/04/2020 £3,650.00 4 Belta 29/06/2020 £12,500.00 5 Jaguar 29/07/2020 £9,950.00 6 Tacoma 14/08/2020 £5,500.00 7 Jaguar 14/08/2020 £35,000.00 8 Marill 14/08/2020 £45,500.00 9 Tacoma 24/09/2020 £14,590.00 10 Probox 12/10/2020 £16,500.00 11 Probox 18/10/2020 £19,500.00 12 Marill 23/10/2020 £65,500.00 13 Probox 27/10/2020 £9,500.00 14 Tacoma 03/11/2020 £3,500.00 15 Probox 10/11/2020 £68,900.00 and here is the example of what i want to achieve including the formulas I expect to use, if correct: Product Year Sales Growth Rate (SGR) Average Growth Rate Mercedes 2019 0 (2019SGR + 2020SGR+2021SGR)/3 Mercedes 2020 (2020 sales - 2019)/2019 sales (2019SGR + 2020SGR+2021SGR)/3 Mercedes 2021 (2021 - 2020)/2020 (2019SGR + 2020SGR+2021SGR)/3 Belta 2019 0 (2019SGR + 2020SGR+2021SGR)/3 Belta 2020 (2020 sales - 2019)/2019 sales (2019SGR + 2020SGR+2021SGR)/3 Belta 2021 (2021 - 2020)/2020 (2019SGR + 2020SGR+2021SGR)/3 Tacoma 2019 0 (2019SGR + 2020SGR+2021SGR)/3 Tacoma 2020 (2020 sales - 2019)/2019 sales (2019SGR + 2020SGR+2021SGR)/3 Tacoma 2021 (2021 - 2020)/2020 (2019SGR + 2020SGR+2021SGR)/3 Thank you in advance.Solved2.3KViews0likes1Comment
Calculating Growth vs Qtr of previous yr in one table (Q1 CY vs Q4 LY)
Hi, So I have a sales table and date table. I want to summarize the quarterly growths vs the same quarter in previous years + I want to calculate the QoQ growth (all in one table). The format is as in table below. What I am struggling with is calculating the growth in Q1 vs Q4 of previous year. How do I make a measure that does that? Year Filter: 20XX Q1 Q2 Q3 Q4 vs Y-1 vs Y-2 vs Y-3 vs LQ vs Y-1 vs Y-2 vs Y-3 vs Lq vs Y-1 vs Y-2 vs Y-3 vs Lq vs Y-1 vs Y-2 vs Y-3 vs Lq Brand A Brand B Brand CSolved907Views0likes2CommentsGrowth rate visual
Hi, I am looking for a visual (Microsoft Certified, so i can publish it on Service and it will be visible for users) that shows a growth rate between multiple choices which are changed dynamically by the user. a good example for this is the custom visual (uncertified) of "Growth Rate Combo Chart" (snapshot below). is there a ceritfied visual or a creative way to present a dynamic growth rate ?726Views0likes0Comments
