Need help ith formula

[erhan_79]

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 amount based on date and based on Sales Group .Here some users adviced me to use to try "running total"  with quick measure but it s not available for my scenarios  , i need a new table as below at right , could you pls give the formula for new table pls 

thanks in advance 

[ryan_mayu · Accepted solution]

@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.

[amitchandak]

@erhan_79 ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[erhan_79]

Hi  @amitchandak  ;

Infact today i mentioned this issue another ticket , i thought that you were busy , so i reopen again topic 

summarize(Table, Date[Date],table[sales Group],"Amount",CALCULATE(SUM(Table[Amount]),filter(date,date[date] <=maxx(date,date[date]))))

 i tried your below formula  that you gave me today  , i created also a date table too , but something wrong and i can not solve what i tried .

i wanted that everyday system will increase value to previous day based on sales group , but formula calculate just totals for each days 

for your easy checking i am sharing my test file 

https://drive.google.com/file/d/1Ug3gP3GtYAdgsQui-Fbbp90MzFhlkVNS/view?usp=sharing

İ have table A ,  below table named "table new " that  i want to create new   , if you should  focus amounts  below  new table  right , first day (15 june ) are 15 June's amounts , but for next days system adding previous day's amount and shows like that , and next day again add all previous day's amounts based on Sales Group  :

i created new table with my test pbix as below , it is not same as you see my above "new table " named

i hope it is clear now : 

[amitchandak]

@erhan_79 ,

I create a measure and used it in display table with date from date table and sales group from table and got the required visual table

Measure = CALCULATE(SUM('Table A'[Amount]),FILTER(all(Dimdate),Dimdate[Date]<=MAXX('Table A','Table A'[Report Date])))