Skip to main content
cancel
Showing results for
Search instead for
Did you mean:

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a \$100 discount. Register Now

Regular Visitor

## Calculate velocity through weeks

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!

1 REPLY 1
Super User

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

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

## Helpful resources

Announcements

#### Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

#### Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

#### Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

#### Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors