Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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
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.
If this post helps, then please consider accepting 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-rm2hJdDpO0
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.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Thank you very much Jihwan, it work perfectly!! Like a charm...
This was great help.
Kind Regards
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |