topic Re: Calculating % Change from Previous Year in DAX Commands and Tips

Calculating % Change from Previous Year

e175429 — Fri, 24 Jan 2025 17:20:00 GMT

Hello all,

This is my current table:

I would like to add a column that shows the % change from previous year for each section.

Currently, I have no measures created.

This is my data:

I would upload the BI file but you have to be a SuperUser to do that.

Any help in pointing me in the right direction would be greatly appreciated.

Regards!

Re: Calculating % Change from Previous Year

DataInsights — Fri, 24 Jan 2025 19:28:01 GMT

e175429,

Try these measures:

Total Served = SUM ( 'Table'[Total Served] )

Percent Change from PY = VAR vCY = MAX ( 'Table'[Year] ) VAR vCYAmount = [Total Served] VAR vPYAmount = CALCULATE ( [Total Served], 'Table'[Year] = vCY - 1 ) VAR vResult = IF ( HASONEVALUE ( 'Table'[Year] ), DIVIDE ( vCYAmount - vPYAmount, vPYAmount ) ) RETURN vResult

For future reference, you can copy your data and paste using the Table icon rather than a screenshot.

Re: Calculating % Change from Previous Year

govind_021 — Sun, 26 Jan 2025 17:41:59 GMT

Hey e175429
Please use below dax formula

YoY % =
VAR CurrentYear = MAX('Sales'[Year])
VAR PreviousYear = CurrentYear - 1

VAR CurrentYearSales =
CALCULATE(
SUM('Sales'[Sales Amount]),
'Sales'[Year] = CurrentYear
)

VAR PreviousYearSales =
CALCULATE(
SUM('Sales'[Sales Amount]),
'Sales'[Year] = PreviousYear
)

RETURN
IF(
NOT ISBLANK(PreviousYearSales),
DIVIDE(CurrentYearSales - PreviousYearSales, PreviousYearSales, 0),
BLANK()
)

Regards
Govind Sapkade ( Data Analyst , Power BI PL 300 Certified , MS Fabric Enthusiast )
Linkdin : www.linkedin.com/in/govind-sapkade-845104225
Youtube : http://www.youtube.com/@govind_dataanalyst

Re: Calculating % Change from Previous Year

e175429 — Mon, 27 Jan 2025 18:53:22 GMT

Thank you very much

Re: Calculating % Change from Previous Year

e175429 — Mon, 27 Jan 2025 18:53:46 GMT

Your solution worked as well. Thank you kindly