A problem for create YoY year change

[baron33]

I use quick measure to create a Yoy change% as below. (with a filter Month= Dec)

You can see it drops to -100% in 2019 -- becasue there is no data for 2019 -- is there a way to hide this -100%? 

Data set looks like this: (It's by year by month but in 2019, the data is only up to July while my chart has a filter =December)

Year             Month

2018            Jan

..

..

..

2018           Dec

2019           Jan

...

2019            July

[v-shex-msft · Accepted solution]

Hi @baron33,

Maybe you can try to pack this measure with if statement to check if current date existed records, return measure result or blank based on if statement.

Measure =
IF (
    CALCULATE (
        SUM ( Table[Amount] ),
        ALLSELECTED ( Table ),
        VALUES ( Calendar[date] )
    ) > 0,
    [YOY measure],
    BLANK ()
)

If this not help, please share some dummy data to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[amitchandak]

@baron33 , Try like

YOY % = if([This Year]=0 || isblank([This Year]),blank(), divide([This Year]-[Last Year],[Last Year]))

This Year = CALCULATE(sum('order'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])))
Last Year = CALCULATE(sum('order'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])-1))

[Greg_Deckler]

Filter for > -99?