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)
