Forum Discussion
FabG
4 years agoNew Member
average every 6 items
Good morning, i have a very short experience with Bi and i need some help to solve an issue: i have a table of mix and relative values and i need to calculate average every 6 item per category. So ...
- 4 years ago
FabG , Please find the attached file. Added index in Power Query. Sum of each type of category on 6th element
amitchandak
4 years agoSuper User
FabG , Please find the attached file. Added index in Power Query. Sum of each type of category on 6th element
- FabG4 years agoNew Member
Hi amitchandak
when i try to open the filed a message says it was edited with a newer version of Bi, but i literally download the desktop version few days ago and no updates are available so far.
- FabG4 years agoNew Member
Hi amitchandak,
i managed to open the file and it works perfectly.
Thank you very much for your help.
- FabG4 years agoNew Member
also if you find some time, can you go through the process and the functions you used?
that would be really useful.
thank you.