Forum Discussion

N7Legend's avatar
N7Legend
Regular Visitor
3 years ago

Get a difference in average per month

Hello,

 

I try to calculate the average time taken by my team to complete tasks, then compare this average per month to the previous month and observe an increase or decrease in this time.

 

Currently I know the average time for the selected month with this formula:

DATEDIFF('Taches'[Date de création],'Taches'[Date de fin],DAY)

 

And I would like a map that shows me directly the percentage according to the current month, compared to the previous month, like this:

 

The problem is that in the formula I don't know how I can refer to the month before the current month, any help would be much appreciated 😃

 

Need Help

2 Replies

  • rajendraongole1's avatar
    rajendraongole1
    Super User
    3 years ago

    Hi N7Legend 

     

    can you try the below measure.

     

    calculate current month and previous month values and then use below measure.

     

    % Change = DIVIDE([Total value], [Prior Month values], blank())-1

    • N7Legend's avatar
      N7Legend
      Regular Visitor
      3 years ago

      Hi,

      Thank you for your prompt answer, what will be the Total Value here ? previous month + current month ?