Avg based on cycle length

[Oceans88]

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

[Oceans88]

HI Jihawn,

Thank you for your reply, actually im not using any measures in this case, its all colmns & calculated columns. Its a bit tuff to share the PBIX as i have som API codes in the file....  😞

[Oceans88]

Shameless bumb

[Jihwan_Kim]

hi, @Oceans88 

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.

[Oceans88]

@Jihwan_Kim  ,

Sorry for the delay. got busy with many things at work. Kindly find attached. PBIX with data
https://we.tl/t-rm2hJdDpO0 

[Jihwan_Kim · Accepted solution]

Hi, @Oceans88 

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.

[Oceans88]

Thank you very much Jihwan, it work perfectly!! Like a charm... 

This was great help. 

Kind Regards