Forum Discussion

ThomasWeppler's avatar
ThomasWeppler
Impactful Individual
4 years ago
Solved

Sum all previous values

Hi Power Bi comunity I want to sum up all previous values for a specifik assignment. Below you can see a table with three colums. An assignemnt ID which show which projekt we are looking at. A m...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    ThomasWeppler , You have try a new column like

     

    sumx(filter(Table, [month index]<=earlier([Month Index]) ),[omsætning])

     

    or

     

    sumx(filter(Table, [month index]<=earlier([Month Index]) && [assignmentid] = earlier([assignmentid]) ),[omsætning])

amitchandak's avatar
amitchandak
Super User
4 years ago

ThomasWeppler , You have try a new column like

 

sumx(filter(Table, [month index]<=earlier([Month Index]) ),[omsætning])

 

or

 

sumx(filter(Table, [month index]<=earlier([Month Index]) && [assignmentid] = earlier([assignmentid]) ),[omsætning])

  • ThomasWeppler's avatar
    ThomasWeppler
    Impactful Individual
    4 years ago

    Thanks for the quick respond.
    Your second line worked perfectly.