Forum Discussion

NickM12's avatar
NickM12
New Member
2 years ago
Solved

Variation between Calculated measure in matrix

Hi, I think this should be simple if you know how! 😉   I have a matrix with a calculated measure (working out the GP% (Margin/Sales)).   I need to subtract one periods GP% from the other, to see...
Need Help
  • hackcrr's avatar
    hackcrr
    2 years ago

    Hi, NickM12 

    You can change DAX to look like this:

    Previous GP% = 
CALCULATE(
    [GP%],
    FILTER(
    'AccManData',
    'AccManData'[Period]= "P4 YTD"
)
)

     

     

    Best Regards,

    hackcrr

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

hackcrr's avatar
hackcrr
Memorable Member
2 years ago

Hi, NickM12 

You can change DAX to look like this:

Previous GP% = 
CALCULATE(
    [GP%],
    FILTER(
    'AccManData',
    'AccManData'[Period]= "P4 YTD"
)
)

 

 

Best Regards,

hackcrr

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

NickM12's avatar
NickM12
New Member
2 years ago

Thanks for your help. I got it to work by using the above & removing the 'Columns',

 

it would have been good to get in the first format, but I think using columns it is difficult