'Power BI - Extrapolate average monthly expenses to remaining months of the year
I am trying to find a solution for the following problem and I do not have that much experience yet with Power BI. Therefore the help of this community would be much appreciated!
I want to use the monthly average of expenses for current year and extrapolate that value for the remaining months of the year.
On top of that I would like to have the possibility to multiply the extrapolated value for the months of may and nov with a value such as 1.1.
So if available expenses are available up to February, the extrapolated outcome should look like this:
Month Expense amount Multiply value
jan 10
feb 6
mrt 8
apr 8
may 8.8 1.1
jun 8
jul 8
sep 8
oct 8
nov 8.4 1.05
dec 8
Thanks in advance for thinking along with me!
Best,
Yoran
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
