compare the total of one month to the previous month on the same dashboard

[Syndicate_Admin]

Hello I want to make a visual that shows the total and on the same dashboard reflect the percentage of increase or decrease compared to the previous month, if it can not be percentage, with numerical value showing the variation I am worth

[Syndicate_Admin]

Hello, I had more urgent things to finish and I still have this doubt pending, I do not know if you would still have availability to review a file if I share it around here?

[rwaanders]

Sure!

[v-shex-msft]

Hi @Anonymous,

Can please share some dummy data with a similar data structure and expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[rwaanders]

You can try something like:

compare =

VAR current = CALCULATE(SUM(Table[Column]))
VAR previous = CALCULATE(SUM(Table[Column]),DATEADD([Datetable[Date],-1,MONTH))
RETURN
(current-previous)/previous

*****

If you add a graph with months from 1 to 12, the current calculation will return the amounts for those periodes. The previous calculation will returns the amount from period 11 at period 12 (so the previous month).

You can then easily calculate the % by calculation "new value minus old value divided by old value".

Make sure to mark the measure as percentage.

[Syndicate_Admin]

thank you for the answer, I actually have to represent in a graph the number of employees per department and that the same graph in each department with a different color can be seen visually if that month the number of employees has increased or decreased

[rwaanders]

Is it possible to share the PBIX file or to generate a sample PBIX file in which the measure can be added?

[Syndicate_Admin]

I can create an example and share it, it's employee information so the original I can't share

[rwaanders]

Please let me know when it's ready, then I'll add the measure.