cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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!

Super User

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

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

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors