Calculate average from prior months

[Anonymous]

Hi, 

I am relatively new to power bi. So was hoping someone can help me out to do this.

I have a monthly sets of data and I need to calculate the average for the current month, using the previous month and current month.

How do i achive this using measures? or do i need to calculate under 'edit queries' and how?

Month	Amount	Average
Jan	2000	-
Feb	800	1400
March	600	700
April	1000	800

Appreciate anyone's help on this.

Thanks

[az38 · Accepted solution]

Hi   @Anonymous

first, its not a good idea to keep only month name in the Month field. for example, you could use last day of month here

if so, then you will need to create a measure (not query editor mode)

Average = (calculate(sum(Table1[Amount]);PREVIOUSMONTH(Table1[Month]))+calculate(sum(Table1[Amount]);ALLEXCEPT(Table1;Table1[Month])))/2 

do not hesitate to give a kudo to useful posts and mark solutions as solution