Forum Discussion
Gabrielfranco
7 years agoFrequent Visitor
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,
2 Replies
- v-chuncz-msft
Community Support
- GabrielfrancoFrequent Visitor
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