How to hide or remove first value in YOY% change matrix

[FOXYBARK]

HI. 

I have the following calculation - 

% Change YOY = CALCULATE(DIVIDE(SUM(Dodeca_Financials[YTD]), [LY]) -1)

which works accurately. I also have a simple viz to display my results. 

I'm looking for a way to hide the first change and have it be dynamic based on my property filter selection. Filter is not shown for security. I'm okay if it says "N/A" or something like that also. 

Thanks

[maruthisp · Accepted solution]

Hi FOXYBARK ,

As per my understanding, You can solve this with a small tweak to your YoY% measure so that it only shows a value when there is a  last year to compare and otherwise returns blank or N/A.

I tried to put your solution in the attached pbix file, please check and let me know if you have questions further.
How to hide or remove first value in YOY% change matrix.pbix

If this reply helped solve your problem, please consider clicking "Accept as Solution" so others can benefit too. And if you found it useful, a quick "Kudos" is always appreciated — thanks! 

Best Regards, 

Maruthi 

LinkedIn - http://www.linkedin.com/in/maruthi-siva-prasad/ 

X            -  Maruthi Siva Prasad - (@MaruthiSP) / X

[gmsamborn]

Hi @FOXYBARK 

would a measure like this help?

% Change YOY =
IF(
	[LY],
    DIVIDE(
        SUM( Dodeca_Financials[YTD] ),
        [LY]
    ) - 1
)

Let me know if you have any questions.