Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Solved! Go to Solution.
Hi @LamSar ,
Please have a try.
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
)
)
If I have misunderstood your meaning, please provide your pbix file without privacy information and your desired output.
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.
Hi @LamSar ,
Please have a try.
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
)
)
If I have misunderstood your meaning, please provide your pbix file without privacy information and your desired output.
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.
FYI: the Stockperiod is in the Date Table
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
105 | |
99 | |
39 | |
30 |