Incorrect Achievement & Growth Percentage
there are 2 table table first is correct and 2nd is showing incorrect result when calculation in power bi i am using below dax formula %'Ach'Jan25 = IFERROR(RCHGTarget[Ach_Jan25]/RCHGTarget[Jan'25],0) %'Grth'Jan = IFERROR(RCHGTarget[Ach_Jan25]/RCHGTarget[Ach_Jan24]-1,0) Ach_Jan25 = IFERROR(CALCULATE(SUM(SaleDump[Value_MN]),FILTER(SaleDump,SaleDump[Concat]=RCHGTarget[Concatch] && SaleDump[Year]="2025" && SaleDump[Month]="Jan" && SaleDump[Spill over]="No")),0) Ach_Jan24 = IFERROR(CALCULATE(SUM(SaleDump[Value_MN]),FILTER(SaleDump,SaleDump[Concat]=RCHGTarget[Concatch] && SaleDump[Year]="2024" && SaleDump[Month]="Jan" && SaleDump[Spill over]="No")),0)
Calculate % Growth change on the basis of Selected Period
Hi All, I am struggling to find the soultion for the below problem statement. I have to create a measure to calculate the %change from selected quarter range. For example, we have data of 2023 from each month with salesDate. @Greg @HotChilli @bhanu @bhanu_gautam @lbendlin @Irwan Many Thanks
Quarterly Growth Calculation
Hello! I'm calculating the average growth rates of some sale values for each quarter. I had to convert the quarters into numeric values to get it to work though. Here is the measure I used: Growth Rate from Average Sales = VAR CurrentQuarter = MAX(Assets[Quarter]) VAR CurrentQuarterSales = CALCULATE(AVERAGE(Assets[Sales]), Assets[Quarter] = CurrentQuarter) VAR PrevQuarter = MAX(Assets[Quarter]) - 1 VAR PreviousQuarterSales = CALCULATE(AVERAGE(Assets[Sales]), Assets[Quarter] = PrevQuarter) RETURN IF(ISBLANK(CurrentQuarterSales) || ISBLANK(PreviousQuarterSales), BLANK(), DIVIDE(CurrentQuarterSales - PreviousQuarterSales, PreviousQuarterSales)) Here is the data: Sales Quarter Qlabel 454 4 Q4 2022 326 4 Q4 2022 542 3 Q3 2022 542 4 Q4 2022 653 3 Q3 2022 553 2 Q2 2022 535 2 Q2 2022 554 2 Q2 2022 553 1 Q1 2022 985 4 Q4 2022 696 4 Q4 2022 662 4 Q4 2022 366 3 Q3 2022 365 1 Q1 2022 665 4 Q4 2022 363 3 Q3 2022 352 1 Q1 2022 233 4 Q4 2022 352 1 Q1 2022 524 2 Q2 2022 235 4 Q4 2022 241 3 Q3 2022 545 1 Q1 2022 658 3 Q3 2022 654 4 Q4 2022 354 3 Q3 2022 365 4 Q4 2022 1000 1 Q1 2022 545 3 Q3 2022 985 2 Q2 2022 654 1 Q1 2022 354 1 Q1 2022 When I turn it into a visualisation it shows the quarter as a number (1 instead of Q1 2022). Is there any way of calculating the growth and then in the visualisation showing the % growth against the quarter as written in the Qlabel column (Q1 2022)? Here is the visualisation currently. the row marked as "4" is the growth from Q3 2022 to Q4 2022.
Growth - Same period last year
Hello Everyone! I'm facing some difficulties in calculating the YoY Growth (sharing QTD sales vs the same period last year) I'm using the formula below to calculate the QTD Orders from this year, and the result is coming right QTD Sales = CALCULATE(COUNT('Orders'[Order Date]),DATESQTD(('Calendar'[ Date]))) The problem is in the formula that calculates the same period from last year: Last Year QTD Orders = calculate(count(Orders'[Order Date]),DATESQTD(DATEADD('calendar'[ Date],-1,YEAR))) It's bringing the result from the WHOLE quarter last year, not from the same period as this year (QTD) I've tried to calculate using the SAMEPERIODLASTYEAR and I got the same results. I don't know if the problem is in my calendar, which was built this way: Calendar = var mindate = year(MIN('Orders'[Order Date])) var maxdate = YEAR(MAX('Orders'[Order Date])) return ADDCOLUMNS( FILTER( CALENDARAUTO(), YEAR([Date]) >= mindate && YEAR([Date]) <= maxdate ), "Year", YEAR([Date]), "Month", FORMAT([Date],"mmmm"), "Month_Number", MONTH([Date]), "Quarter", FORMAT([Date], "\QQ" ) ) I already marked the calendar as date table. Thank you so much in advance
