Hello all,
I am new to PowerBI and I hope you can help me with this issue. I am trying to calculate a YTD average of the YTD. for further clarification I have this table:
| Date | Owned Space (sqm) |
| January | 1000 |
| February | -100 |
| March | 20 |
| April | 0 |
| May | -40 |
| June | 32 |
| July | 108 |
| August | -2 |
we usually start with the current owned space in January and register the chage in the following months. Therefore, the best way to measure our current owned space is YTD, wich I obtain with a dax measure:
YTD sqm= TOTALYTD('Table 1'[Owned Space (sqm)],'Table1'[Date])
I then get the following table:
| Date | Owned Space (sqm) | YTD sqm |
| January | 1000 | 1000 |
| February | -100 | 900 |
| March | 20 | 920 |
| April | 0 | 920 |
| May | -40 | 880 |
| June | 32 | 912 |
| July | 108 | 1020 |
| August | -2 | 1018 |
Now, what I want to calculate is the YTD average of YTD sqm. Which month by month would be something like
YTD average sqm March= (YTD sqm January+ YTD sqm February + YTD sqm March)/3
and the same for each month
| Date | Owned surface (sqm) | YTD sqm | YTD average sqm |
| January | 1000 | 1000 | 1000.0 |
| February | -100 | 900 | 950.0 |
| March | 20 | 920 | 940.0 |
| April | 0 | 920 | 935.0 |
| May | -40 | 880 | 924.0 |
| June | 32 | 912 | 922.0 |
| July | 108 | 1020 | 936.0 |
| August | -2 | 1018 | 946.3 |
Wich measure can I use to achieve this (last column)?
Thank you in advance! 😊
