Forum Discussion
paulinamaj
5 years agoFrequent Visitor
Dateadd + another hierarchy
Hi, I made a measure that calculates the% change between the previous month, quarter, year. % Change Units = VAR CurrentValue = 'Sales Ths Units'[Total Sales Units] VAR PreviousValue = ...
v-kelly-msft
Community Support
5 years agoHi paulinamaj ,
I guess your measure doesnt contain the hierarchy you added in,that's why you see blank results.You need to add the hierarchy in your measure.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!