Forum Discussion

nmanselmo's avatar
nmanselmo
Frequent Visitor
8 years ago
Solved

YoY Measure showing only final

Hello All! First post, excited to join community.   I have the following data set and I am trying to add a new measure to the very right hand side calculating the Margin Growth. Any ideas?  ...
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    Try this

     

    =IF(ISERROR(CALCULATE([Gross Margin],NEXTYEAR(Calendar[Year]))),([Gross Margin]-CALCULATE([Gross Margin],PREVIOUSYEAR

    (Calendar[Year])))/[Gross Margin],BLANK())

     

    Ensure that the years in your visual are dragged from the calendar table and there is a relationship between the Date column of your source data table to the date column of your calendar table.

     

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

Try this

 

=IF(ISERROR(CALCULATE([Gross Margin],NEXTYEAR(Calendar[Year]))),([Gross Margin]-CALCULATE([Gross Margin],PREVIOUSYEAR

(Calendar[Year])))/[Gross Margin],BLANK())

 

Ensure that the years in your visual are dragged from the calendar table and there is a relationship between the Date column of your source data table to the date column of your calendar table.

 

Hope this helps.