cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Oceans88
Helper III
Helper III

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

 

 

Capture1.PNG

 

Please let me know if you have an idea of how i could acomplish this. 

 

Greatful for any possible help. 

 

KR

1 ACCEPTED SOLUTION
Jihwan_Kim
Community Champion
Community Champion

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.

 

View solution in original post

6 REPLIES 6
Oceans88
Helper III
Helper III

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....  😞

 

 

Shameless bumb

Jihwan_Kim
Community Champion
Community Champion

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.

@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
Community Champion
Community Champion

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.

 

View solution in original post

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

 

This was great help. 

 

Kind Regards

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors