Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello I've been trying to solve this puzzle without any luck....
What I need is to calculate the velocity per week, in the excel table below for instance, on Period1 the velocity is 1.395 =I21/(I20*4.3)
then on Period 2, since there is no sale, the velocity is calculated =(I21/J20)/4.3 last month sale vs the sum of periods 1+1=2 periods instead of 1, period 3 is the same 6 PKG, per week divided by 3 periods 4.465... and so on.
My problem is that I can't figure out how to create the measure that go check if there is sale on the period, if not go back until it find a positive value, then sum the total amount of periods and divided by thePKG per week.
Your help will be greatly appreciated!
Thank you!
Sample/example data would really help here. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
User | Count |
---|---|
98 | |
90 | |
78 | |
72 | |
65 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |