Forum Discussion

sparvez's avatar
sparvez
Helper I
2 years ago

Display Sum

Hello Altruists,   A Table is given like below.  "Week"  will be increased or decreased randomly.   Person-- Week1-- Week2-- Week3-- ... Hoover-- 2-- 13-- 30-- ... Franklin-- 8-...
Need Help
Daniel29195's avatar
Daniel29195
Community Champion
2 years ago

hello , sparvez 

 

you need to unpivot your table from power query  first. 

then you need a cumulative measure : 
try using the following : 

calculate (

sum( table[col] , 

all(dimdate) , 

dimdate[date] <= max(dimdate[date])
)

 

or you can use window function : 

Measure 11 =
CALCULATE(
    SUM('Table (13)'[Value]),
    CALCULATETABLE(
    WINDOW(
        0,
        ABS,
        1,
        SUMMARIZE(
            'Table (13)',
            'Table (13)'[Index],
            'Table (13)'[Person],
            'Table (13)'[week nb]
        ),
       
        ORDERBY('Table (13)'[week nb] ,  asc)
    ),
    all('Table (13)'[week nb]),
    'Table (13)'[week nb] <= MAX('Table (13)'[week nb])
))
 

 


 

 

hope this is what you are looking for. 

 

best regards