Forum Discussion
Variation between 2 or more months
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)])
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.
4 Replies
- parry2kSuper User
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.
- VivicloserRegular Visitor
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 😞
- parry2kSuper User
Vivicloser not sure why. I guess you need to provide more information. Maybe a sample pbix file will help to look into it.
- VivicloserRegular Visitor
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!