Filtered margin issue ("Actual %Margin" - "Month -1%Margin")

[as3znaus]

Hi everyone!

This is my first post in this community 🙂

We've created an excel with the company financial information, and now we are trying to build a report to show the results in weekly progress meetings.

I have a measure called " %Margin" and I've used filters to show a column of "Actual % Margin" (October) and another one of "Month -1 % Margin" (September). 

Let's say that I get the next results: 

Actual % Margin = 0.58 %

Month -1 % Margin = 1.42 %

For the next step, I need a box with a new meassure that shows the difference between margins following the expresion ("Actual %Margin" - "Month -1%Margin") 

Something like:  "% Margin A vs. M-1" = -0.84

How can I get that??

Thanks in advance

[v-yuezhe-msft · Accepted solution]

Hi @as3znaus,

Would you mind sharing sample data of your scenario? Based on your description, you want to calculate difference of Margin from previous month, in this case, you can consider to create a new measure using PARALLELPERIOD function.

And you can review the examples in the following blog and similar thread about how to use PARALLELPERIOD function.

DAX – PARALLELPERIOD
Calculate difference from previous month


Thanks,
Lydia Zhang

[as3znaus]

Hi @v-yuezhe-msft,

I have try the PARALLELPERIOD function with an example file and I'm pretty sure it worked...

Please find attached the files I used.

https://we.tl/I2Dqbwo78H

Thanks a bunch!

[v-yuezhe-msft]

Hi @as3znaus，

Based on your PBIX file, you have resolved  this issue, right? If that is the case, we will appreciate that if you can accept helpful reply as answer. That way, it will be easier for other community members to find the solution when they get same issues.

Thanks,
Lydia Zhang

[as3znaus]

no one?