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 Everyone,
I would like to be able to help me with this problem that I currently have.
I have a table with 3 fields (Source, WeekOffset, Amount), in the first table of the image you can simply see the organization of the matrix:
The problem is that I need the total each week offset to be the start of the following week. Just like an opening balance.
Does anyone know how this can be done?
I thank you in advance for your cooperation.
Solved! Go to Solution.
Hi,
I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.
Please check the below picture and the attached pbix file.
I hope the below can provide some ideas on how to create a solution for your datamodel.
Value total measure: =
SUM( Data[Value] )
Value all source: =
CALCULATE ( [Value total measure:], ALL ( Source[Source], Source[Index] ) )
Expected result measure: =
VAR _prevwk =
CALCULATE ( [Value all source:], WINDOW ( 1, ABS, -1, REL, ALL ( Week[Wk] ) ) )
RETURN
IF (
SELECTEDVALUE ( Source[Source] ) = "Prev Wk",
_prevwk,
_prevwk + [Value total measure:]
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi,
I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.
Please check the below picture and the attached pbix file.
I hope the below can provide some ideas on how to create a solution for your datamodel.
Value total measure: =
SUM( Data[Value] )
Value all source: =
CALCULATE ( [Value total measure:], ALL ( Source[Source], Source[Index] ) )
Expected result measure: =
VAR _prevwk =
CALCULATE ( [Value all source:], WINDOW ( 1, ABS, -1, REL, ALL ( Week[Wk] ) ) )
RETURN
IF (
SELECTEDVALUE ( Source[Source] ) = "Prev Wk",
_prevwk,
_prevwk + [Value total measure:]
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Yes this is pefect!.
I didn't have a Source table, only a Calendard an Detail table, but I will create the Source table from values and add the Previous Week.
Thanks a lot
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |