Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Margin % difference for 2 years

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.   
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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's avatar
ALLUREAN
Icon for Solution Sage rankSolution Sage
4 years ago

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