SAMEPERIODLASTYEAR x hierarchy (Year-Month) chart

[Gabrielfranco]

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,

[v-chuncz-msft · Accepted solution]

@Gabrielfranco ,

You may try to set Show items with no data.

[Gabrielfranco]

@v-chuncz-msft 

Hi mate, so, I analysed it better and decided to filter dates equal to or above 2017, avoiding this kind mistake about comparing previous year/month that not exists...now it's working as I expected