Forum Discussion
N7Legend
3 years agoRegular Visitor
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. Curr...
rajendraongole1
3 years agoSuper User
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
3 years agoRegular Visitor
Hi,
Thank you for your prompt answer, what will be the Total Value here ? previous month + current month ?