Matrix - Showing only the final value

[rydajo96]

Hi, I have the following table and I want to show the period on period changes for the entire 1H 2019. I am not interested in the indiviudal period change for specific industry. May I know how do I go about doing this?

Thank you!

[v-jayw-msft · Accepted solution]

Hi @rydajo96 ,

You could use ALLEXCEPT() function.

https://learn.microsoft.com/en-us/dax/allexcept-function-dax .

Best Regards，

Jay