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,
ActualDate - Amount
10/22/16 $1000
10/23/16 $1100
10/25/16 $ 900
11/01/16 $1000
11/11/16 $1100
11/21/16 $1200
12/01/16 $400
12/28/16 $500
I want to do avarage monthly, which is 1000 for Oct/2016, 1100 for Nov/2016, 450 for Dec/2016. Then accumulate current month average and averages of the months before current month. The visual should be like:
I googled a lot, but almost scenaria is discussing doing average such as totalAmount/monthAmount.
Thanks in advance.
Solved! Go to Solution.
Hi,
Try the solution provided here and see if it works for you
You might need to change the base value of the quick measure to:
Hi,
Try the solution provided here and see if it works for you
You might need to change the base value of the quick measure to:
@Gordonlilj, thanks a lot!
Solution let me learn a lot such as datebetween, summarize, thanks again.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |