Margin % difference for 2 years

[Anonymous]

Hi,

 My margin % is from profit divide sales. How do I calcualate the margin % difference for both year? There is subtotal in the formatting, but I want difference instead. 

[v-stephen-msft · Accepted solution]

Hi @Anonymous ,

You want to replace subtotal with the result you want. You can use the ISINSCOPE function.

Measure = IF(ISINSCOPE('Table'[Year]),[Percentage],[Difference])

The example I attached is relatively simple, you can refer to it.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ALLUREAN]

Hi, @Anonymous 

Try creating a measure like:

YoY Variance Margin =
VAR __PREV_YEAR = CALCULATE([YourMargin%]), DATEADD('Date'[Date], -1, YEAR)

//Replace 'Date'[Date] by your date column coming from Calendar table

VAR __CURR_YEAR = [YourMargin%] --Selected by slicer
RETURN
__CURR_YEAR - __PREV_YEAR

It is suggested that you have date table and using date from there 'Date'[Date]

[YourMargin%] - you should replace it by your Margin measure calculation