Forum Discussion
Average is not calculated correctly Need Help
Hello I need your help again, here is the measure for it. Ø / Monat = ROUNDUP(AVERAGEX( VALUES('Date (2)'[Date].[MonthNo]), CALCULATE([Verkauft]) ),0 ) U...
lbendlin
Thanks for your effort but unfortunately this is not what I need.
I am already a small step further and know why PB calculates this incorrectly.
Pictures say more than 1000 words
| 01.05.2022 | 01.06.2022 | 01.07.2022 | 01.08.2022 | 01.09.2022 | 01.07.2022 |
|
123 | 50 | 70 | 80 | 45 | 74 | 60 | 63,2 |
654 |
|
| 60 |
|
|
| 60,0 |
654 | 0 | 0 | 60 | 0 | 0 | 0 | 10,0 |
Empty cells are ignored in both Excel and PB.
Now the question arises can I get around this?
Or would it be feasible if I set the date filter to 6 months that I then get the number 6 as a value.
Look at the here please.
- lbendlin
Super User
To report on things that aren't there you need to use cross joins and/or disconnected tables.
