Forum Discussion

Gabrielfranco's avatar
Gabrielfranco
Frequent Visitor
7 years ago
Solved

SAMEPERIODLASTYEAR x hierarchy (Year-Month) chart

Hi guys,

 

I've got a problem that I can not show the correct data of the month % of growth when calculated with blablabla and applied hierarchical filter.

here my dax mensure: 

%growth = IFERROR([Sales]/CALCULATE([Sales];SAMEPERIODLASTYEAR(Calendar[Date]))-1;BLANK())

Any help to solve that, please?

Cheers,