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.

Anonymous's avatar
Anonymous
Not applicable
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.