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

Helper III

## Calculation of End Stock

Hello everyone,

I have a question.

I have the following datamodel:

And I have this report:

The data shown is based on the selected value "Stockperiode 2022/04" in the slicer.

I now want to create to create a measure "End Stock" which is the quantity which is left of a specific article between the 1st and 7th day of the next stockperiod.

So this measure needs to be calculated on the first 7 days of Stockperiode 2022/05.

What would be the best way to do this?

Any help would be greatly appreciated.

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @LamSar ,

Create a measure.

``````Measure =
VAR previous7days =
CALCULATE (
MIN ( 'table'[date] ) - 7,
FILTER (
ALL ( 'table' ),
'table'[Stockperiod] = SELECTEDVALUE ( 'table'[Stockperiod] )
)
)
VAR Mindate =
CALCULATE (
MIN ( 'table'[date] ),
FILTER (
ALL ( 'table' ),
'table'[Stockperiod] = SELECTEDVALUE ( 'table'[Stockperiod] )
)
)
RETURN
CALCULATE (
SUM ( 'table'[value] ),
FILTER (
ALL ( 'table' ),
'table'[date] < Mindate
&& 'table'[date] >= previous7days
)
)

``````

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 REPLIES 2
Anonymous
Not applicable

Hi @LamSar ,

Create a measure.

``````Measure =
VAR previous7days =
CALCULATE (
MIN ( 'table'[date] ) - 7,
FILTER (
ALL ( 'table' ),
'table'[Stockperiod] = SELECTEDVALUE ( 'table'[Stockperiod] )
)
)
VAR Mindate =
CALCULATE (
MIN ( 'table'[date] ),
FILTER (
ALL ( 'table' ),
'table'[Stockperiod] = SELECTEDVALUE ( 'table'[Stockperiod] )
)
)
RETURN
CALCULATE (
SUM ( 'table'[value] ),
FILTER (
ALL ( 'table' ),
'table'[date] < Mindate
&& 'table'[date] >= previous7days
)
)

``````

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helper III

FYI: the Stockperiod is in the Date Table

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.

#### Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

#### Fabric Community Update - September 2024

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

Top Solution Authors
Top Kudoed Authors