Forum Discussion
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.
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.
2 Replies
- ALLUREAN
Solution Sage
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_YEARIt is suggested that you have date table and using date from there 'Date'[Date]
[YourMargin%] - you should replace it by your Margin measure calculation
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.
