Forum Discussion
Avg based on cycle length
Dear All.
Please have a look at the imge below. What im trying to do is calculate the avarage of the daily "Close price" based on "Cycle.Length.Breakup". in the example below the breakup is setup for 2 days. eg. 11-22-33-44
Please let me know if you have an idea of how i could acomplish this.
Greatful for any possible help.
KR
Hi, Anonymous
Thank you for your message.
Please check the link down below whether it is correctly done.
I added AVG Measure and AVG column.
https://www.dropbox.com/s/mvfm9fto4hrrf96/Demo_Avg.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, and give a big thumbs up.
6 Replies
hi, Anonymous
I am not sure about how your measures look like, but if it is OK with you, please share your sample pbix file's link here, then I can try to have a look and come up with a desirable solution.
In my opinion, I think this can be possibly done by using Groupby function for a virtual table inside the measure.
Thank you.
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, and give a big thumbs up.
Sorry for the delay. got busy with many things at work. Kindly find attached. PBIX with data
https://we.tl/t-rm2hJdDpO0Hi, Anonymous
Thank you for your message.
Please check the link down below whether it is correctly done.
I added AVG Measure and AVG column.
https://www.dropbox.com/s/mvfm9fto4hrrf96/Demo_Avg.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, and give a big thumbs up.