Forum Discussion
Helper IILast week in the table calculation
Please try
=
DIVIDE (
[#Total Accumulative Amount],
MAXX (
TOPN (
1,
ADDCOLUMNS (
ALLSELECTED ( 'Date'[Year Week number] ),
"@MaxAmount", [#Max Amount]
),
'Date'[Year Week number]
),
[@MaxAmount]
)
)
Community ChampionHi danielcontente
Please try
=
DIVIDE (
[#Total Accumulative Amount],
CALCULATE ( [#Total Accumulative Amount], ALL ( 'Date'[Year Week number] ) )
)
danielcontenteThanks so much tamerj1
however, i use a slicer for week, so if i filter for week 52, for example, there would be a new #max expected amount in week 52 and not 53. In this case, how can i do in order to consider the max value in the table depending on the filter?
- tamerj1
Try
=
DIVIDE (
[#Total Accumulative Amount],
CALCULATE (
[#Total Accumulative Amount],
ALLSELECTED ( 'Date'[Year Week number] )
)
)- danielcontente
Hi tamerj1
it didnt work.
It keeps dividing by the max amount not the amount of the max week.
Example:
because the amount in week 52 > week 53, even if a select week 53, it will divide by the amount of week 52.
- danielcontente
example:
If i filter for week 52, then the table below would show only until week 52, and therefore all the values in the column "#Total Accumulative Amount" should be divided by the #Max Amount of week 52..