Forum Discussion

erhan_79's avatar
erhan_79
Post Prodigy
6 years ago
Solved

Need help ith formula

Hi there ;   i need  your  kind support to calculate below issue on my report  ;   i have a table which one's name is Table A as below at left , i would like to calculate day by day increasing of...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    6 years ago

    erhan_79 

     

    Please try below measure to create a new table.

    Table 3 = 
SUMMARIZE('Table (2)','Table (2)'[reportdate],'Table (2)'[salesgroup],"amount",CALCULATE(sum('Table (2)'[Amount]),FILTER(ALLEXCEPT('Table (2)','Table (2)'[salesgroup]),'Table (2)'[reportdate]<=EARLIER('Table (2)'[reportdate]))))

    hope this is helpful.

ryan_mayu's avatar
ryan_mayu
Super User
6 years ago

erhan_79 

 

Please try below measure to create a new table.

Table 3 = 
SUMMARIZE('Table (2)','Table (2)'[reportdate],'Table (2)'[salesgroup],"amount",CALCULATE(sum('Table (2)'[Amount]),FILTER(ALLEXCEPT('Table (2)','Table (2)'[salesgroup]),'Table (2)'[reportdate]<=EARLIER('Table (2)'[reportdate]))))

hope this is helpful.