Variation between 2 or more months

[Vivicloser]

Good afternoon everyone (:  I have a question, if anyone has an idea of how to solve it, I would be very grateful!
The calculation of "Variação" results when we select only 2 months. When we select more than two months, it only calculates the variation between the last and the first month, and ignores the rest. What is desired is that, for example, a value for the variation between July and September appears, and a value for the variation between September and November. How else could I write the Delta expression when selecting more than 2 months?

Variação =

VAR Valor1 = CALCULATE ('Selecao de medidas'[Key_Operation], 'Data_M'[Data] = Min('Data_M'[Data]))

VAR Valor2 = CALCULATE ('Selecao de medidas'[Key_Operation], 'Data_M'[Data] = Max('Data_M'[Data]))

VAR Diferenca = Valor2 - Valor1

VAR Resultado = DIVIDE (Diferenca, Valor1) *100

RETURN Resultado

The Key_Operation measure referred to in the Variation is as follows:

Key_Operation = SWITCH(TRUE(),

'Selecao de medidas'[Select_Operation] = "Closed Act.", [Closed Activities],

'Selecao de medidas'[Select_Operation] = "Interactions", PeriodType[Interactions],

'Selecao de medidas'[Select_Operation] = "Distinct Users", PeriodType[Distinct Users],

'Selecao de medidas'[Select_Operation] = "AVG TMT(seg)", PeriodType[AVG TMT(seg)])

[parry2k]

@Vivicloser not sure why. I guess you need to provide more information. Maybe a sample pbix file will help to look into it. 

[Vivicloser]

It already worked! Now a detail, is it possible that "%Sales Diff PM" does not appear in the column for the first month?
Thank you very much for your help!

[parry2k · Accepted solution]

@Vivicloser there is already a post on this Comparing with previous selected time period in DAX - SQLBI

✨ Follow us on LinkedIn and  to our YouTube channel

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

[Vivicloser]

I really appreciate the suggestion, but it still isn't working for my data, idk why. No results appear in the matrix for these measurements that I created from the video 😞