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.
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
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 |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |