Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |