Forum Discussion
Avoid Allexept
Hi,
I have problem with my running totals. it is very slow. I think it's because of the allexept function.
can i avoid to use allexcept function and made my calculation more optimil ?
Runing Total =
VAR CurrantIndex = MIN ( 'ShiftTable'[Index] )
VAR LastReset = [ResetIndex]
VAR IndexToUse =
FILTER (
ALLEXCEPT ( ShiftTable, Branches[Branch], Kadr_LookUP[Name], 'Date'[Year], 'Date'[Month], 'Date'[Month Day] ),
ShiftTable[Index] >= CurrantIndex && LastReset = [ResetIndex] )
VAR Result = CALCULATE ( SUMX ( ShiftTable, ShiftTable[Real Time] ), IndexToUse )
RETURN Result
Hi PowerMan1
Take a look at the linked discussion:https://stackoverflow.com/questions/76393885/powerbi-running-total-over-large-number-of-values
may be window () function can help
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
3 Replies
Hi PowerMan1
Take a look at the linked discussion:https://stackoverflow.com/questions/76393885/powerbi-running-total-over-large-number-of-values
may be window () function can help
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
i want to reset data with this measure (in every even index):
ResetIndex = VAR Res = MAX ( ShiftTable[Index] ) RETURN IF ( ISODD ( Res ), Res + 1, Res )and context is:
year
month
day
branch
personN
sorry for my English
