% change not showing for last year in table

[Anonymous]

I'm sure someone can easily resolve this, I can't.  Here is my DAX for Current Yr Growth %:

Current Yr Growth% =

VAR py_sales =

CALCULATE (

[Total Past ACV and Estimate],

FILTER (

ALLSELECTED ( 'Calendar Table'[Year] ),

'Calendar Table'[Year]

= MAX ( 'Calendar Table'[Year] ) - 1

)

)

VAR YOY_Sales = [Total Past ACV and Estimate] - py_sales

RETURN

DIVIDE ( YOY_Sales, py_sales )

See image, the last year in the table will show percent. You can't see it all, but the percentage to the right of $12.3M is missing.

[Anonymous · Accepted solution]

I created a new column for previous years sales, I think I was using SAMEPERIODLASTYEAR somewhere and that was messing things up. 

Prev Yr PV = CALCULATE([Total Past ACV and Estimate], PREVIOUSYEAR('Calendar Table'[Date]))

YoY Change = DIVIDE( [Total Past ACV and Estimate] - [Prev Yr PV] , [Prev Yr PV])

This created a percentage for the last year in the list. 

[Anonymous]

Hi @Anonymous ,

It seems that in the rows which the value of Current Yr Growth % is blank, the corresponding values of YOY_Sales and py_sales is blank (one of them is blank or both are blank). Could you please  provide the formula of measure [Total Past ACV and Estimate] and sample data in relevant tables to make troubleshooting in order to find the cause to solve it? Thank you.

Best Regards

Rena

[az38]

@Anonymous 

interesting. have you tried to debug?

RETURN

YOY_Sales

then

RETURN

py_sales