Forum Discussion
How to aggregate table based on moving sum
Hi, Anonymous
Please correct me if I wrongly understood your question.
Please check the below picture if that is what you are looking for.
The link to the sample pbix file is down below, and all measures are in the file.
https://www.dropbox.com/s/t2ypgefpqu2otdi/dancrist.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster.
Super UserHi, Anonymous
Please correct me if I wrongly understood your question.
Please check the below picture if that is what you are looking for.
The link to the sample pbix file is down below, and all measures are in the file.
https://www.dropbox.com/s/t2ypgefpqu2otdi/dancrist.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster.
Yes. This helps a lot, thank you!
I think 'Start Date' is selecting the date preceding the max period instead of the first date in the period, but that's a simple fix if I add 1 to the return (ie
enddates - nperiods + 1). I think I should be able to sort the rest of this out, thanks.