Table doesn't show data but shows total

[Anonymous]

Hi!

I need some help with a table in Power BI.

This is my table, and I do not understand why for 'Total depreciation USD Last year' I don't get the values, but I do get the right total amount.

Measures used:

Total Depreciation USD = sum(Depreciation[AmountUSD])

Total depreciation USD last year = CALCULATE([Total Depreciation USD], SAMEPERIODLASTYEAR(Depreciation[Date]))

Year over year = [Total Depreciation USD]-[Total depreciation USD last year]

Any help will be appreciated!

Thank you

Belen

[Payeras_BI]

Hi @Anonymous ,

This is because you are slicing by Year and Month coming from your Date table but in your "Total depreciation USD last year" measure you are using Depreciation[Date].

Use this instead:

Total depreciation USD last year = CALCULATE([Total Depreciation USD], SAMEPERIODLASTYEAR(Date[Date]))