Forum Discussion
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 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
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.
4 Replies
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.
erhan_79 ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
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 :
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])))
